Using a Calc spreadsheet as a data source

From NeoWiki

Revision as of 22:38, 16 January 2007 (edit) Sardisson (Talk | contribs) (no longer {{fixme}}) ← Previous diff		Current revision (22:21, 18 June 2008) (edit) (undo) Lorinda (Talk | contribs) m (remove reference to "one or many" spreadsheets; an odb file can only connect with one spreadsheet doucment)
(One intermediate revision not shown.)
Line 1:		Line 1:
	{{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 a spreadsheet. 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.	+	* Choose {{menu|Database}} from the {{menu|New}} sub-menu of the {{menu|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.	+	* In the {{window|Database Wizard}} window which opens, select {{prefName|Connect to an existing database}}, and in the pop-up menu, choose {{prefName|Spreadsheet}} and click on the {{button|Next}} button.
-	* Click on the ''Browse'' button and select the spreadsheet which you wish to use as a data source (<tt>.ods</tt>, <tt>.sxc</tt>, or <tt>.xls</tt> format). Click on the ''Open'' button and then on the ''Next'' button.	+	* Click on the {{button|Browse}} button and select the spreadsheet which you wish to use as a data source (<tt>.ods</tt>, <tt>.sxc</tt>, or <tt>.xls</tt> format). Click on the {{button|Open}} button and then on the {{button|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.	+	* Keep the default option {{prefName|Yes, register the database for me}}. The option {{prefName|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.	+	* Click the {{button|Finish}} button.
-	* Name the the new database, and choose a location to save it. Finally, click the ''Save'' button.	+	* Name the the new database, and choose a location to save it. Finally, click the {{button|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.		'''N.B'''. Any modifications made to the original spreadsheet will automatically be reflected in the tables of the database you have just created.

---

Current revision

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