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.