At 18:33 14/03/2008 -0400, Kenn Goutal wrote:
I have a bunch of things that I've been keeping in (OO/Calc)
spreadsheets. They're at the point where I really need to have them
in databases or, if possible, in a single database.
[...]
Recommendations?
o Create a new database.
o Click on Tables in the Database panel, so that the Tables panel
appears below.
For each spreadsheet:
o Open the spreadsheet in Calc.
o If necessary, insert field names as the first row of the data.
o Select the data.
o Copy the data from Calc and paste it into the Tables panel in the
database. (Under Windows, you can drag the data instead.)
o In the "Copy table" panel, choose the data that you want to import.
Alternatively, if you have registered your new database as a data
source (probably in the second panel of the Database Wizard), you can
do all this without explicitly opening the database itself. (Does
this also work only under Windows?) For each spreadsheet:
o Open the spreadsheet in Calc.
o Go to View | Data Sources (or F4).
o In the left panel of data sources, open the database to show its
"Tables" sub-entry.
o If necessary, insert field names as the first row of the data.
o Select the data.
o Drag the data onto the "Tables" sub-entry.
o In the "Copy table" panel, choose the data that you want to import.
Each of your spreadsheets becomes a separate table in your new database.
I trust this helps.
Brian Barker
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
