Using a Calc spreadsheet as a data source

Revision as of 22:59, 30 January 2007 by Sardisson (Talk | contribs)

It is possible to create a database from one or many spreadsheets. Each sheet of a Calc document will become a table in the new database.

Choose Database from the New sub-menu of the File menu.
In the Database Wizard window which opens, select Connect to an existing database, and in the pop-up menu, choose Spreadsheet and click on the Next button.
Click on the Browse button and select the spreadsheet which you wish to use as a data source (.ods, .sxc, or .xls format). Click on the Open button and then on the Next button.
Keep the default option Yes, register the database for me. The option Open the database for editing is optional; if it is checked, the database will open at the end of the process.
Click the Finish button.
Name the the new database, and choose a location to save it. Finally, click the Save button.

N.B. Any modifications made to the original spreadsheet will automatically be reflected in the tables of the database you have just created.

This article in other languages: FranÃ§ais Italiano