[QODBC-Desktop] How to Use QODBC with OpenOffice Base
Posted by Rajendra Dewani (QODBC Support) on 14 April 2014 04:24 PM
How to Use QODBC with OpenOffice Base
For MS Access 64-bit, Please refer: To how to Configure QODBC to Work With 64-bit MS Excel.
Setup QODBC to use with OpenOffice Base
First open OpenOffice Base from: Start>>All Programs>>OpenOffice>>OpenOffice Base
First, select the "Create a new database" option to import QuickBooks data.
Now please click the "Next" button.
Now please click "Finish," & save the newly created database to your specified location & give the name to the database (In this example, I use the database name as QuickBooks_Data).
You can see the newly created database is ready for different operations.
Please click on the File menu, go to the Wizard option & please select the Address Data Source option.
Please select the "Other external data source" option & click "Next."
Now please click on the "Settings" button to import QuickBooks Data.
Now please select "ODBC" as the database type.
Now please click the "Browse" button & choose the data source "QuickBooks Data."
Please click on the "Test Connection" button to test the connection.
You can see a successful connection dialog box. Please click on the "OK" button, then please click the "Next" button.
Now please select the "Use catalog for file-based database" option & click on the "Finish" button.
Now you can see the connection is established. Please select the table you want to import (Here, I choose the Account table).
You can assign the field to the table by clicking the "Field Assignment" button.
Now register the data source in OpenOffice by choosing the database location & database name (In this example registered OpenOffice database name is Adresses2.odb), then click on the "Finish" button to complete the import process.
Please click on the "File" menu to open the registered OpenOffice database.
Please provide your registered OpenOffice database through the "Browse" button(By default, it is saved in the "Documents" folder.
The registered OpenOffice database will open in a new window.
Now please click on "Table." You will get an all list of QuickBooks tables.
Now please click on any table name whose data you want to fetch (In this example, I have clicked on Account table).
You can query the imported table from the "Query" pane by selecting "Create Query in SQL View."
Please type SQL statements in the query editor window & press F5 to Run Query.
OpenOffice is not compatible with the write operation with QuickBooks. You can use OpenOffice only for the read operation.