QuickBooks Data Access

1 post

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 http://www.qodbc.com/…  QuickBooks does not use SQL Server.

Are You Ready For QuickBooks Multi User?

Visit painlessquickbooks.com to find out.