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: [email protected]
Clifton R. Liles    "Software to the Stars"    [email protected]
Pearland, TX 77581   [email protected]  [email protected]
- 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: [email protected]
For additional commands, e-mail: [email protected]

Reply via email to