Linking QuickBooks and MS Access

Question: I’m trying to set up a link from an Access database to the tables in Quick Books so I can run some custom queries on the data, but so far I haven’t been able to find the tables.

Assuming that the data is stored in SQL Server, I tried setting up an ODBC connection to the data, but I can’t find the database, and there doesn’t seem to be a *.dsn driver.

How can I create a link in Access so I can read the data in the QuickBooks tables?

Answer: Assuming you are using version 2009, purchase and install QODBC Driver Version 9.0 for QuickBooks 2009 at…  QuickBooks does not use SQL Server.

Are You Ready For QuickBooks Multi User?

Visit to find out.


Comments are closed.

%d bloggers like this: