Creating a Database in NeoOffice 1.x

From NeoWiki

Revision as of 23:17, 15 September 2005 (edit) Sardisson (Talk | contribs) m (tweak formatting a bit) ← Previous diff		Revision as of 11:09, 20 November 2005 (edit) (undo) Sardisson (Talk | contribs) (rebranding) Next diff →
Line 1:		Line 1:
-	While NeoOffice/J 1.1 and OpenOffice.org/X11 1.1.x do not contain a database component similar to Microsoft Access, it is still possible to create a database (this is handy if you don't have access to [[Using MySQL|MySQL]] or another external database).	+	While NeoOffice 1.2 Alpha and OpenOffice.org/X11 1.1.x do not contain a database component similar to Microsoft Access, it is still possible to create a database (this is handy if you don't have access to [[Using MySQL|MySQL]] or another external database).
	[[User:Max_Barel|Max]] offered the following tips on [http://trinity.neooffice.org/modules.php?name=Forums&file=viewtopic&p=11456#11456 trinity]:		[[User:Max_Barel|Max]] offered the following tips on [http://trinity.neooffice.org/modules.php?name=Forums&file=viewtopic&p=11456#11456 trinity]:
Line 16:		Line 16:
	# use the data-source as planned (mailing and such)		# use the data-source as planned (mailing and such)
-	See the NeoOffice/J help for details.	+	See the NeoOffice Help for details.
	Before editing this wiki page I ([[User:Max_Barel|Max]]) checked the above process.		Before editing this wiki page I ([[User:Max_Barel|Max]]) checked the above process.
	[[Category:Tips and Hints]][[Category:NeoOffice/J]][[Category:OpenOffice.org]]		[[Category:Tips and Hints]][[Category:NeoOffice/J]][[Category:OpenOffice.org]]

---

Revision as of 11:09, 20 November 2005

While NeoOffice 1.2 Alpha and OpenOffice.org/X11 1.1.x do not contain a database component similar to Microsoft Access, it is still possible to create a database (this is handy if you don't have access to MySQL or another external database).

Max offered the following tips on trinity:

There is a simple database functionality in OOo and thus NeoJ : use the dbase file format. This is not a full-featured database but it works for most cases.

How-to:

1. display data-source pane
2. create a new data source
3. select a dbase format
4. choose the folder (directory) where the table files will be stored. If the folder already contains .dbf files, the tables they describe are automatically added to the database. This is a simple way to import dBase files
5. close the panel
6. add a table to the base, defining colums as you need.
7. open the recently created table and add/modify/delete item.
8. use the data-source as planned (mailing and such)

See the NeoOffice Help for details.

Before editing this wiki page I (Max) checked the above process.