Connecting BarTender to a QuickBooks database

Overview

Intuit’s QuickBooks application is a very popular accounting and business management program that contains its own proprietary database.  There are two ways to connect BarTender to Quickbooks.

 

Connecting to QuickBooks directly via ODBC

According to the QuickBook's documentation there currently is no OLE DB driver for communication with their database. According to this support article only specific versions of QuickBooks Enterprise Solutions come with the read-only QODBC driver that’s required for BarTender (or any external application) to connect to the QuickBooks back-end database.

It's important to verify that the version of QuickBooks you own has the QODBC driver available. If not, follow the link listed in the support article to obtain. If there are any problems installing/configuring the QuickBooks QODBC driver please contact Quickbooks directly. Once it’s been installed and configured, you will be able to use the resulting ODBC connection in Windows to connect a BarTender label format to the QuickBooks database.   

Note: QuickBooks is a 32 bit application, and the QODBC driver is natively 32 bit, so there shouldn’t be any compatibility issues once they have the driver installed. 

 

Exporting data from QuickBooks to an Excel or CSV file

QuickBooks has the capability to export data into an Excel or CSV file. This is similar to the option above but it will not require the QODBC driver.

When using this method, it’s important to mention that although it doesn’t require any additional software, it is a manual process. Additional maintenance will be required to ensure that you are using the most current data. If you are having technical difficulties exporting your data from Quickbooks to Excel or CSV please contact Intuit’s technical support team.

Tip: Once you have established how you will utilize your QuickBooks database using one of the two options above you will need to add the database connection to a BarTender label format. For help connecting to your database view please see Getting Started With Database Connections
Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request

Comments

Please sign in to leave a comment.