HOW-TO use Microsoft Access databases from within OpenOffice.org 1.1

Short Description
OpenOffice.org (OOo) is able to read and write from a wide variety of … Create an ODBC Data Source within OpenOffice.org for each database (you only …

Website: www.openoffice.org | Filesize: 317kb

Content
HOW-TO use Microsoft Access databases from within
OpenOffice.org 1.1
OpenOffice.org (OOo) is able to read and write from a wide variety of databases, as
long as they support one of the standard interface specifications such as ODBC or
JDBC. Fortunately, Microsoft Access (MS-Access) supports ODBC. This HOW-TO takes
you step by step through the process of linking OOo to MS-Access using ODBC.
The process has three simple steps:
1. Create an ODBC Data Source for each database you want to use (you only need to
do this once per database)
2. Create an ODBC Data Source within OpenOffice.org for each database (you only
need to do this once)
3. Enjoy using your MS-Access databases in OOo!
Creating an ODBC Data Source for the MS-Access database
Within MS-Windows, choose Start -> Settings -> Control Panel and double-click the
ODBC Data Sources icon
to run the ODBC Data Source Administrator:
Page 1 of 4 26.02.2004Click on the Add button to display the Create New Data Source dialogue box:
Select the Microsoft Access Driver and press the Finish button. This will display the
ODBC Microsoft Access Setup dialogue box:
Give the new data source a name (e.g. the same name as your MS-Access database)
and a description. Use the Select button to select your MS-Access database file
(*.dbf) and press OK.
Page 2 of 4 26.02.2004…