Hi Joep,
J.L. Blom schrieb:
Hi,
It's maybe requested more but I can't find how to convert - or import -
a spreadsheet (or document table) into a database table.
I have an address list made in an MSword table. I can convert it to a
spreadsheet but I cannot find how to import it in a database (native OO)
or (better) transform it into a database table.
There to 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. Leave it open.
2. Open your Calc-table.
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.
You will get the "Copy Table"-dialog, which leads you through the import.
Instead of drag&drop you can also use Copy&Paste.
4. Mark your data in the Calc-table and copy them into the Clipboard.
5. Go to the databasefile and use Edit - Paste.
You will get the "Copy Table"-dialog too.
kind regards
Regina
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
