Find answers to common questions about the ODBC Driver and QuickBooks Desktop.
Open Database Connectivity (ODBC) is a standard that allows different applications to communicate and exchange data with each other. Through ODBC, you can create spreadsheets in Excel, tables in Access, and reports in such ad hoc report writers as Crystal Reports that reflect your real-time QuickBooks data.
You can also use this feature to design your own reports (even combining data from multiple company files), personalize invoices, create mail merges, etc. In addition, you can write your own queries using Structured Query Language (SQL).
The QODBC driver allows administrator access to your QuickBooks data using third-party applications such as Microsoft Excel, Access, or Crystal Reports.
QuickBooks Enterprise Solutions
Intuit has formed an alliance with Intuit Developer Network member FLEXquarters to provide a read-only QODBC driver for QuickBooks data, allowing you to share data between QuickBooks and hundreds of other applications.
Note: Windows Servers (Windows Server 2003, Windows Server 2008, etc) require the server-only driver which is not part of the read-only driver QuickBooks Enterprise Solutions comes with. For server only or additional functionality, you can upgrade to a read/write driver. Fees may apply.
The read-only and read-write drivers are available for purchase for QuickBooks Pro or Premier products from FLEXquarters. It is not necessary to upgrade to QuickBooks Enterprise Solutions to use the QODBC Driver.
To begin the installation process for the driver, go to File > Utilities > Setup ODBC. Detailed Instructions can be found here.
You will need to download the driver from FLEXquarters. Detailed instructions including the link to download the driver can be found here.
The READ WRITE or Server version of the ODBC driver for QuickBooks is available for purchase from FLEXquarters.
Both versions of the ODBC driver are exactly the same at their core. The only differences are in terms of the functions that are enabled. This is based on the license used when you install the driver.
KB 1000248 - Description of the Intuit ODBC driver and the FLEXquarters ODBC driver has more information on the differences between the versions.
Access to payroll data, multiple Ship To addresses, unit of measure and other information is not available due to the limitations from the QuickBooks Software Development Kit (SDK).
Support and Resources Questions
QuickBooks support for the ODBC Driver is limited to installation and configuration of the ODBC driver for QuickBooks Enterprise Solutions (QBES). QBES will also assist in troubleshooting connection errors. For technical issues beyond the areas mentioned, please refer to QODBC.com web site, or the QODBC.com forum.
Fees may apply.
Purchasing, Downloading and Technical Support is handled through FLEXquarters for QuickBooks Pro and QuickBooks Premier users.
To purchase the Read-Only, Read-Write or Web Server edition, click Buy Now.
To download QODBC Driver for QuickBooks, click Downloads.
For QODBC Free Technical Support Forum click Support/FAQ.
ODBC Read-Only Resources are available here or click QODBC.COM Knowledgebase for Tutorials, Troubleshooting, Syntax and QODBC Support.
QODBC.com provides you detailed instructions to set up ODBC access to Microsoft Excel, Microsoft Access or Crystal Reports. Click on the application you are using for setup instructions.