Here's a similar idea I tried:
Open the Calc file to the spreadsheet in question.
Open the Base file and click on the Tables icon.
Select the rows and columns I want from the spreadsheet,
including column headings.
Drag to the selection to the Base window,
to the lower panel on the right, currently titled "Tables".
I get a dialog box titled "Copy table".
I let it use the default table name (lazy me),
and leave "(O) Definition and data" checked.
I click [ Next> ].
I get a dialog box titled "Apply columns".
I click [ >> ] to copy all the "Existing columns"
to the new database table.
I click [ Next> ].
I get a dialog box titled "Type formatting".
Strangely, even the "date" field, which was of type "date"
in the spreadsheet, has been converted to VARCHAR,
along with all the other values, which are integers.
With a table this 'narrow', not a show-stopper,
but surprising and annoying that it didn't figure out
that it DATE was appropriate for fields with dates in them
and that INTEGER would be a good choice for fields
that have only integers in them.
Then I notice the "Automatic type recognition" box,
and click [ Auto ]. That causes all (!) fields
to be converted to type DOUBLE.
But to continue:
I fix up all the Field Types.
I click [ Create ].
I get a popup titled "Microsoft Visual C++ Runtime Library",
saying:
(X) Runtime Error!
Program: C:\...\soffice.BIN
abnormal program termination
That sure *looked* like a good way to do it, but I guess not.
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
