« Return to Thread: How to make a Database from a spread sheet and Vlookup

How to make a Database from a spread sheet and Vlookup

by Clifton Liles :: Rate this Message:

Reply to Author | View in Thread

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

--
mailto: c.liles@...
Clifton R. Liles    "Software to the Stars"    lilescr@...
Pearland, TX 77581   c.r.liles@...  c.liles@...
- Speaking for myself!  Standard disclaimer applies. -
This address may *not* be used for unsolicited mailings.
Failure is not an option. It comes bundled with your Microsoft products.



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