I am using the official 2.0.3 version of OpenOffice on Ubuntu.
I have tried several times tonight to import data from a spreadsheet to
a database, using the instructions given in the documentation on the
list, that is,
How can I import a spreadsheet table to a database?
Thanks to Regina Henschel for the answer at the mailing list
[email protected]
There two ways
(1) You can create a database file which gives you access to the
calc-table. But you cannot alter the table within base, but must use
the calc-table
(2) You can create a new database file and import your calc table.
I refer to the way (2).
1. Create a new, empty database or open an existing. Leave it open.
2. Open your Spreadsheet-table.
3. Mark your data in the Calc-table and copy them into the Clipboard.
4. Go to the databasefile and use Edit - Paste.
You will get the "Copy Table"-dialog, which leads you through the import.
Instead of Copy&Paste you can also use drag&drop.
3. Reduce the windows, so that you can see the Database pane of the
databasefile window beside the calc table.
4. Mark all your data in the Calc-table including the headings.
5. Drag them to the databasefile window and drop them to the
"Tables"-Icon in the Database-pane.
Whenever I try this, I get to the part of "How Many Lines of Text" and
when I mark "Auto", the program crashes, with that generic message, "The
[program] has failed, but your data can be saved by restarting OpenOffice.
I am fairly sure that somewhere in here there is a part of the process
that I am doing wrong, due to not knowing exactly what commands I ought
to be giving.
Can anyone give me any hints on this?
JimW
