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

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