Link Access to Quickbooks

I am quering if it is possible to connect access to quickbooks via an ODBC connection?  I have been asked to create an access database to collect information and at th end of the day have the balances loaded into an undeposited account in quickbooks.

Can someone explain how this approach can be done.

I am fairly advance with the use of VBA and SQL commands.
RDLFCAsked:
Who is Participating?
 
Jeffrey CoachmanMIS LiasonCommented:
All of this info is on their FAQ page:
http://qodbc.com/support.htm
0
 
Jeffrey CoachmanMIS LiasonCommented:
Investigate QODBC

http://www.qodbc.com/qodbc.htm

install, configure, ... then in Access simply click
External data-->Import-->More--->ODBC
...to connect to the QB data (tables)
0
 
Jeffrey CoachmanMIS LiasonCommented:
Just note that some quickbook experts report that Quickbooks has been known to change it's inner structure without notice, ...thus possibly jumbling your custom interface functionality...
0
 
RDLFCAuthor Commented:
Thanks for your update.  

I usually follow your instructions when creating ODBC connections to an SQL server.
"External data-->Import-->More--->ODBC
...to connect to the QB data (tables)"

however when I create the new databasource I select an SQL Server driver.  What driver will I have to select for Quickbooks?  

I read the link you posted.  Do I have to download the drivers from the link in order for it to show up when selecting an ODBC driver?
0
 
Jeffrey CoachmanMIS LiasonCommented:
;-)
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.