Re: How to make a Database from a spread sheet and Vlookup

> 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@...