Was this page helpful?
Thank you!

Comments or suggestions?



Enter Email Address (optional)
email

ODBC driver frequently asked questions

Find answers to common questions about the ODBC Driver and QuickBooks.

General Questions
What is the ODBC driver?
Can I use the ODBC driver with my QuickBooks?
How do I install the driver?
How do I update to the Read Write or Server driver?
What are the differences between the Intuit version and the Flexquarters versions?
Is all data accessible - including payroll?

Support and Resource Questions
Can I contact QuickBooks Technical support for assistance?
What resources are available?
How do I set up QODBC in Microsoft Excel, Microsoft Access or Crystal Reports? 

General Questions


What is the ODBC driver?


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.
 

Can I use the ODBC driver with my QuickBooks?
 

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.

QuickBooks Pro/Premier

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.
 

How do I install the driver?
 

QuickBooks Enterprise Solutions

To begin the installation process for the driver, go to File > Utilities > Setup ODBC. Detailed Instructions can be found here.

 

QuickBooks Pro/Premier

You will need to download the driver from FLEXquarters. Detailed instructions including the link to download the driver can be found here.
 

How do I update to the Read Write or Server driver?
 

The READ WRITE or Server version of the ODBC driver for QuickBooks is available for purchase from FLEXquarters.
 

 

What are the differences between the Intuit version and the FLEXquarters versions?
 

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.

Is all data accessible - including payroll?

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

Can I contact QuickBooks Technical support for assistance?
 

QuickBooks Enterprise Solutions:

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.

QuickBooks Pro or Premier:

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.

Fees may apply.

What resources are available?
 

ODBC Read-Only Resources are available here or click QODBC.COM Knowledgebase for Tutorials, Troubleshooting, Syntax and QODBC Support.

How do I set up QODBC in Microsoft Excel, Microsoft Access or Crystal Reports?
 

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.

 

If this information does not answer your question, you can read discussions and post messages and questions relating to your issue on the Intuit QuickBooks Community site for free. You can contact an agent for additional guidance. Fees may apply.

 

 

                   

KB ID# INF12836
11/1/2014 1:57:06 AM
PPRDQSSWS400 9102 Pro 2013 3bf351