Devart ODBC Driver for QuickBooks Desktop: Your Company File as SQL Tables
Devart ODBC Driver for QuickBooks Desktop is a Windows ODBC driver, $179.95 a year at checkout, that lets Excel, Power BI, Access, SQL Server and other tools query a QuickBooks Desktop company file (.QBW) with SQL. It's for bookkeepers, accountants and in-house developers who need QuickBooks Desktop figures in their own reports or systems rather than only in QuickBooks' built-in reports.
QuickBooks Desktop keeps the books on a local or network PC, so cloud reporting tools can't simply sign in to it. An ODBC driver on that Windows machine is the usual way to get the data into a spreadsheet or a database that refreshes on its own.
Quick facts
- Version: 1.4.0, released October 16, 2026; first released December 12, 2023
- Developer: Devart
- System: Windows Vista or newer, 32-bit or 64-bit, Terminal Server supported, .NET Framework 4.5 or later. No macOS or Linux edition
- Connects to: a QuickBooks Desktop company file (.QBW, or a .QBA accountant's copy), optionally through a proxy
- Price: $179.95 a year for one desktop user; $349.95 perpetual
- Trial: 30 days, evaluation only, with a free Devart account
- Refund: full refund within 30 days of purchase only if a technical problem keeps it from working and Devart's support can't fix it
- What we checked: the order page charged $179.95 for Desktop for Windows with one year of updates on a yearly subscription, renewing at $179.95, and the download page listed version 1.4.0 with a 35.02 MB installer, on November 15, 2026. We didn't connect it to a QuickBooks company file
Download Free Trial Buy Now
Overview
When you create the data source, you browse to the company file, and the driver presents QuickBooks lists and transactions as tables. Devart's sample query on the product page joins the Item list to Account through each item's income account, then groups the result by item type and account type: the kind of cross-list report that takes several exports in QuickBooks itself.
Queries can use JOINs, subqueries, WHERE filters, GROUP BY, aggregate functions and ORDER BY, and INSERT, UPDATE and DELETE write changes back. The driver is Unicode throughout, so company files with Hebrew, Cyrillic or Chinese names and memos come through intact.
Features
Live QuickBooks data in Excel
Devart ODBC Driver for QuickBooks Desktop works with Excel's Power Query (Get Data, From ODBC), the Data Connection Wizard, Microsoft Query and Power Pivot, so a management pack can refresh straight from the company file. Use the driver with the same bitness as your Excel: 64-bit Excel needs the 64-bit driver.
QuickBooks next to your other databases
Devart ODBC Driver for QuickBooks Desktop can be added to SQL Server as a linked server or to Oracle as a database link, and is documented with SSIS and Informatica, which lets you copy QuickBooks data into a warehouse or join it with CRM and inventory data.
Settings for slow or picky tools
Devart ODBC Driver for QuickBooks Desktop has a 60-second connection timeout and a separate query timeout, an option to return foreign keys only when a tool really needs them (they slow metadata reads), a UTC Dates switch, and ANSI or Unicode string types for tools that only handle one.
Deployment across many PCs
Devart ODBC Driver for QuickBooks Desktop is one standalone installer with no client libraries, supports silent installation and Group Policy deployment, and since version 1.1.0 stores passwords encrypted in the DSN.
Benefits
- Reports QuickBooks can't build. Combine lists and transactions in one SQL query instead of stitching exports together.
- Less re-keying. Write records into QuickBooks from another system with INSERT instead of typing them.
- Accountant-friendly. Works with a .QBA accountant's copy as well as the company's .QBW file.
- Stays on your network. The books never leave the office to be reported on.
Real-World Uses
- Month-end pack. A bookkeeper refreshes an Excel workbook of sales by item and account from QuickBooks Desktop instead of exporting reports one at a time.
- Margin analysis in Power BI. A small manufacturer joins QuickBooks items with production data from its own database.
- Accounting in the data warehouse. An IT team copies QuickBooks tables into SQL Server each night with SSIS.
- Client reviews. An accountant queries a client's accountant's copy to check item and account setup before year-end.
Who It's For, and Who Should Skip It
Buy this driver if your business or your clients still run QuickBooks Desktop on Windows and you want its data in Excel, Power BI or a database on a schedule, or you build integrations that read and write QuickBooks records.
Skip it if you're on QuickBooks Online, which needs Devart's separate QuickBooks Online driver; if QuickBooks' own reports and exports already give you what you need; or if your reporting runs on a Mac or Linux, since this driver is Windows-only.
Usage Guide
- Download the installer with your free Devart account and install it on the Windows PC that has access to the company file.
- Activate it with your license key or use the 30-day trial.
- Check rights first: if QuickBooks Desktop runs as Administrator, run your reporting tool as Administrator too (Devart notes a mismatch can make the connection fail with no clear error).
- Open ODBC Data Sources (32-bit or 64-bit, matching your tool), add a DSN with Devart ODBC Driver for QuickBooks Desktop and browse to the .QBW or .QBA file; fill in the proxy only if you need one.
- Click Test Connection, then pick the DSN in Excel, Power BI or your code.
Before you buy
Writing to your books with SQL is powerful and unforgiving. Back up the company file before the first INSERT, UPDATE or DELETE, test on a copy, and give a reporting-only setup no write access in the tools that use it.
Where it falls short
- Windows only. There's no macOS or Linux edition, unlike several other Devart drivers.
- Sparse table documentation. Devart doesn't publish a full list of the QuickBooks Desktop tables and fields, so check the ones you need in the trial.
- Permissions trip people up. Mismatched Administrator rights between QuickBooks and your tool can break the connection silently.
- Pricier than most Devart drivers. At $179.95 a year it costs more than the $109.95 to $139.95 of many other Devart ODBC drivers.
What Users Say
Reviews of the QuickBooks Desktop driver on its own haven't been published; review sites rate Devart's ODBC drivers together.
Devart ODBC Drivers as a family
On Capterra the line scores 4.7 out of 5 across 26 reviews, and on G2 4.6 out of 5 across 18. Those reviewers mostly used Devart's database and Salesforce drivers; they mention quick installation and dependable connections, and they knock the price when several drivers are needed and the SQL learning curve.
Comparisons
QuickBooks Desktop driver vs. Devart's QuickBooks Online driver
The two are separate products at the same checkout price of $179.95 a year. The Desktop driver opens a company file on your Windows PC or network; the Online driver signs in to Intuit's cloud. Pick the one that matches your QuickBooks edition; a company moving from Desktop to Online needs the Online driver afterwards.
One driver vs. the ODBC Universal Bundle
Devart's Universal Bundle includes all 92 of its ODBC drivers from $499.95 a year for a desktop. If QuickBooks data has to be combined with two or more other sources Devart covers, such as a CRM and a database, the bundle can cost less than buying each driver.
Editions and Pricing
| Edition (Windows) | 1-year subscription | Perpetual | Who can use it |
|---|
| Desktop | $179.95 | $349.95 | One user at a time on one computer |
| Server Standard | On the order page | $1,999.95 | Many users on one server with up to 6 cores, one legal entity |
| Server Enterprise, Site, OEM | Quote | Quote | Any core count, every PC in the company, or bundling the driver with your own product |
The Buy Now button orders Desktop for Windows on a 1-year subscription by default; the order page is where you switch to Server Standard, a perpetual license, or a 2- or 3-year term, and add priority support. Buying 5, 10 or 20 copies takes 5, 10 or 15 percent off.
FAQs
Does the Devart QuickBooks Desktop driver work with QuickBooks Online?
No. Devart ODBC Driver for QuickBooks Desktop reads Desktop company files only; QuickBooks Online is covered by Devart's separate ODBC Driver for QuickBooks Online.
Can the QuickBooks Desktop ODBC driver open an accountant's copy?
Yes. Devart ODBC Driver for QuickBooks Desktop accepts both .QBW company files and .QBA accountant's copies as the Company File.
Why does my QuickBooks Desktop ODBC connection fail without an error?
Often it's Windows rights. Devart's guide for the QuickBooks Desktop driver says that if QuickBooks Desktop runs as Administrator and your tool doesn't (or the other way round), the connection may fail with no specific message; run both with the same rights.
Can I use the QuickBooks Desktop driver on a Mac?
No. Devart ODBC Driver for QuickBooks Desktop runs only on 32-bit and 64-bit Windows, including Windows Server and Terminal Server.
Can I get my money back if the QuickBooks driver doesn't suit me?
Only if it fails technically. Devart's ordering FAQ allows a full refund within 30 days when a technical problem or bug stops Devart ODBC Driver for QuickBooks Desktop working and support can't resolve it, so try it on your own company file during the 30-day trial.
What happens to the subscription after a year?
Devart ODBC Driver for QuickBooks Desktop's subscription renews automatically each year at $179.95 unless you cancel; when a subscription ends, the driver stops working. A perpetual license keeps running without renewal, though updates and support stop.
System Requirements
- Windows Vista or newer, 32-bit or 64-bit, including Windows Server and Terminal Server
- .NET Framework 4.5 or later
- 35.02 MB installer; only one version of the driver installed
- Access to a QuickBooks Desktop company file (.QBW or .QBA)
- The same Windows rights level for QuickBooks Desktop and your ODBC tool
Conclusion
Devart ODBC Driver for QuickBooks Desktop is a sensible $179.95 a year for firms still on QuickBooks Desktop that report in Excel or Power BI, or feed accounting data into SQL Server, because it turns the company file into tables you can join and refresh. Its weak points are thin documentation of which QuickBooks tables it exposes and a Windows-only build. If your books are moving to QuickBooks Online soon, buy the Online driver instead. Otherwise, run the trial against a copy of your company file and check the tables you need are there.
Download Free Trial Buy Now