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, personalize invoices, create mail merges, etc. In addition, you can write your own queries using Structured Query Language (SQL).
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.
Can I contact a QuickBooks agent for assistance?
Intuit support is extremely 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, please reach out to us at the number below.
Get hep with ODBC for QuickBooks Desktop. Give us a call at (855) 227-0700 and get all of your questions answered today!