To learn more about the cost of the ODBC driver, check out the pricing for your version of QuickBooks. To update your driver, you can purchase it in the FLEXquarters. How can I update the read/write or server driver? You'll need to buy the driver from FLEXquarters, then you can download and install it. Select Setup ODBC, then download and install the ODBC driver.How can I install the driver? To install in QuickBooks Enterprise Note: It's not necessary to upgrade to your subscription to use the QODBC driver. That allows you to share data between QuickBooks and hundreds of other applications. Can I use the ODBC driver in QuickBooks? QuickBooks EnterpriseĪlong with Intuit Developer Network member FLEXquarters, we have a read-only QODBC driver for your company file. You can only share login info with users that already have open access to QuickBooks. ODBC users don’t have the same permissions as QuickBooks users.
Even if you’re an admin, you’ll need to create new user credentials to connect to QuickBooks for Custom Reporting. ODBC has a separate login from your QuickBooks account. How are ODBC users different from QuickBooks users? In addition, you can write your own queries using Structured Query Language (SQL). You can also use this to design your own reports using data from multiple company files, personalize invoices, create mail merges, and more. Through ODBC, you can create spreadsheets in Microsoft Excel, tables in Microsoft Access, and create reports in Crystal Reports that reflect your company file. Open Database Connectivity (ODBC) driver is a standard application that allows admin access to your company file using third-party applications like Microsoft Excel, Microsoft Access, or Crystal Reports. If you’re not comfortable working with databases, make sure to work with an IT person.
Note: You’ll be accessing your company file data in QuickBooks using multi-user mode. What is Custom Reporting?Ĭustom Reporting gives read-only access to your QuickBooks database, then you can create custom reports in ODBC compatible applications like Microsoft Access or Excel. Get answers to frequently asked questions about Open Database Connectivity (ODBC) driver and how it works in QuickBooks Desktop.
0 kommentar(er)
