« Return to Thread: How to make a Database from a spread sheet and Vlookup
Re: How to make a Database from a spread sheet and Vlookup
by drewjensen
::
Rate this Message:
Clifton Liles wrote:
> Olivier Hallot wrote:
>> As far as I remenber, you can drag a sheet from your spreadsheet into
>> the table view of Base, and the import will run automagically, with a
>> wizzard to assist you in defining the column data type.
>>
>> Clifton Liles escreveu:
>>> Hi All
>>> I am trying to create/populate a Base from a spread sheet. I have
>>> followed the vague directions in the help file with no luck.
>>> 1 I created a new base with no tables defined and copied the
>>> material ( with the first row as headers). Then I pasted it into
>>> the Tables area, Paste Special spread sheet. I got the message 'No
>>> Table format could be found.'.
>>> 2 I created the table and put in an ID field as the Key. Did a
>>> Paste Special. I got the message 'No Table format could be found.'.
>>> 3 I added the element of the spread sheet that I wanted and did a
>>> Paste Special. I got the message 'No Table format could be found.'.
>>> From reading this list, I think VLOOKUP may help me do what i want?
>>> The only information I have found is for EXECL VLOOKUP, is there any
>>> for the OO (Basic?) form? Is it just a Calc function or can I use
>>> it in Base?
>>>
>>> For the record I am using XP and office 3.0.0.
>>> Thanks for your Help
>>> Cliff
>>>
>>
>> ------------------------------------------------------------------------
>>
>> ---------------------------------------------------------------------
>> To unsubscribe, e-mail: users-unsubscribe@...
>> For additional commands, e-mail: users-help@...
> Hi All
> I got it to work. The data is a comma separated list from another
> data base and came up as a Excel data sheet. I opened it as a Calc
> and then things work. Well not quite what I wanted but with a little
> playing around I think I can get it. Thanks for your help
> Cliff
>
Hi Clifton,
OK - well I know this is late.
The best way that I've found to move the data from Calc to Base is a 3
file transfer.
1 - I create a base file as 'Connect to eisting' in the wizard and
select a type of Spreadsheet.
- Select the Calc file with the data you want to move to base
2 - Create your Base file (embedded, MySQL, whatever)
3 -Now drag your data as a 'table' from that first file to the second,
launching the table copy wizard.
My personal experience has been that this gives the best results for
transferring the data.
Drew
---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@...
For additional commands, e-mail: users-help@...
> Olivier Hallot wrote:
>> As far as I remenber, you can drag a sheet from your spreadsheet into
>> the table view of Base, and the import will run automagically, with a
>> wizzard to assist you in defining the column data type.
>>
>> Clifton Liles escreveu:
>>> Hi All
>>> I am trying to create/populate a Base from a spread sheet. I have
>>> followed the vague directions in the help file with no luck.
>>> 1 I created a new base with no tables defined and copied the
>>> material ( with the first row as headers). Then I pasted it into
>>> the Tables area, Paste Special spread sheet. I got the message 'No
>>> Table format could be found.'.
>>> 2 I created the table and put in an ID field as the Key. Did a
>>> Paste Special. I got the message 'No Table format could be found.'.
>>> 3 I added the element of the spread sheet that I wanted and did a
>>> Paste Special. I got the message 'No Table format could be found.'.
>>> From reading this list, I think VLOOKUP may help me do what i want?
>>> The only information I have found is for EXECL VLOOKUP, is there any
>>> for the OO (Basic?) form? Is it just a Calc function or can I use
>>> it in Base?
>>>
>>> For the record I am using XP and office 3.0.0.
>>> Thanks for your Help
>>> Cliff
>>>
>>
>> ------------------------------------------------------------------------
>>
>> ---------------------------------------------------------------------
>> To unsubscribe, e-mail: users-unsubscribe@...
>> For additional commands, e-mail: users-help@...
> Hi All
> I got it to work. The data is a comma separated list from another
> data base and came up as a Excel data sheet. I opened it as a Calc
> and then things work. Well not quite what I wanted but with a little
> playing around I think I can get it. Thanks for your help
> Cliff
>
Hi Clifton,
OK - well I know this is late.
The best way that I've found to move the data from Calc to Base is a 3
file transfer.
1 - I create a base file as 'Connect to eisting' in the wizard and
select a type of Spreadsheet.
- Select the Calc file with the data you want to move to base
2 - Create your Base file (embedded, MySQL, whatever)
3 -Now drag your data as a 'table' from that first file to the second,
launching the table copy wizard.
My personal experience has been that this gives the best results for
transferring the data.
Drew
---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@...
For additional commands, e-mail: users-help@...
« Return to Thread: How to make a Database from a spread sheet and Vlookup
| Free embeddable forum powered by Nabble | Forum Help |
