![how to use openoffice database from access how to use openoffice database from access](https://img.bhs4.com/34/0/340DC95A9A713B82AD775E3B2EC43D44F256E26D_large.jpg)
- #HOW TO USE OPENOFFICE DATABASE FROM ACCESS HOW TO#
- #HOW TO USE OPENOFFICE DATABASE FROM ACCESS DRIVER#
To create an SQL query, click Queries in the Database pane, then click Create Query in SQL View…Įnter your query in the query text box and click Run Query (F5).To view the data from a specific table, double-click the table name. When the database opens, you will see the list of tables from your data source diplayed in OpenOffice or LibreOffice Base workspace.You will be prompted to give a name to your new database and select the directory where you want to store it. You can keep the default selection in this dialog box and click Finish.If you have entered valid credentials, you will see a success message. To test the connection to your data source, click Test Connection, input your credentials and click OK.
#HOW TO USE OPENOFFICE DATABASE FROM ACCESS DRIVER#
Alternatively, you can specify these parameters in the data source settings of your ODBC Driver for WordPress and leave these fields empty in Database Wizard. If you are connecting to a password protected database, check the Password required field.
#HOW TO USE OPENOFFICE DATABASE FROM ACCESS HOW TO#
The article describes how to use Apache OpenOffice and LibreOffice to access ODBC data sources using the respective driver. In this screencast tutorial, we show you the process of connecting OpenOffice Base to a Microsoft Access database. Connecting to WordPress from OpenOffice and LibreOffice using ODBC Driver for WordPress While you cannot directly open a Microsoft Access database file in OpenOffice Base, it is possible to connect Base to an Access database, and manipulate the data contained within it.