Get answers to frequently asked questions about Open Database Connectivity (ODBC) driver and how it works in QuickBooks Desktop.
What is ODBC driver?
Open Database Connectivity (ODBC) driver is a standard application that allows different programs to communicate and exchange info with each other. It allows admin access to your company file using a third-party applications like Microsoft Excel, Access, or Crystal Reports.
Through ODBC, you can create spreadsheets in Excel, tables in Access, and create reports in Crystal Reports that reflect your real-time company file. You can also use this feature to design your own reports, combining data from multiple company files, personalise invoices, create mail merges, etc. In addition, you can write your own queries using Structured Query Language (SQL).
Can I use the ODBC driver in QuickBooks?
|QuickBooks Enterprise||Along with Intuit Developer Network member FLEXquarters, we have a read-only QODBC driver for your company file. That allows you to share data between QuickBooks and hundreds of other applications.
Note: Window Servers (Window Server 2003, 2008, etc) requires the server only driver. For server only or additional features, you can upgrade to a read/write driver. Fees may apply.
|QuickBooks Desktop Pro/Premier||The read-only and read-write drivers are available in FLEXquarters.
Note: It's not necessary to upgrade to your subscription to use the QODBC driver.
How can I install the driver?
To install in QuickBooks Enterprise
- Go to File, then select Utilities.
- Select Setup ODBC, then download and install the ODBC driver.
To install in QuickBooks and Premier
You'll need to buy in FLEXquarters to download and install it.
How can I update the read/write or server driver?
To update your driver, you can purchase it in the FLEXquarters.
How much does the ODBC driver cost?
To learn more about the cost, you can check out the applicable prices for your QuickBooks product.
Note: If you are working with the read/write driver, check out their support site or contact a FLEXquarters agent. There are certain limitations in data due to QuickBooks Software Development Kit (SDK). Some of these info are not available like payroll data, multiple Ship To address, and unit of measure.
Can I contact a QuickBooks agent for assistance?
QuickBooks Desktop Enterprise
Our support agent is limited for installation, assistance in troubleshooting errors, and configuration of the ODBC driver for QuickBooks Enterprise Solutions (QBES) users. For technical errors beyond the areas mentioned, refer to their support site. Fees may apply.
QuickBooks Desktop Pro and Premier
What are the available resources that I can use?
Take a look at our Custom Reporting Guide (PDF).
Get more help in their site for available tutorials, troubleshooting steps, and additional support.
How to set up QODBC in Microsoft Excel, Microsoft Access or Crystal Reports?
Select these application for detailed instructions or check out their site to learn more.