Using a Calc spreadsheet as a data source

From NeoWiki

Revision as of 22:37, 16 January 2007 (edit) Sardisson (Talk | contribs) (translation; thanks to jgd for writing it!) ← Previous diff		Revision as of 22:38, 16 January 2007 (edit) (undo) Sardisson (Talk | contribs) (no longer {{fixme}}) Next diff →
Line 1:		Line 1:
-	{{fixme}}{{handbook sidebar|DatabaseTOC}}	+	{{handbook sidebar|DatabaseTOC}}
	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.		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.

---

Revision as of 22:38, 16 January 2007

Introduction to NeoBase Configuring MySQL using ODBC and Mac App Store versions of NeoOffice Configuring MySQL using JDBC and NeoOffice 2.x Configuring MySQL using ODBC Configuring hsqldb Configuring postgresql Configuring FileMaker Pro Working with dBase databases Using a Calc spreadsheet as a data source Using your database with NeoOffice

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 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.