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
--
Olivier Hallot
Scinergy Consulting
Tel (021) 2224-3224, (021) 8822-8812
Rio de Janeiro, Brasil
http://www.scinergy.com.br
OpenOffice.org L10N project leader for Brazil
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
