RDLFC
asked on
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.
Can someone explain how this approach can be done.
I am fairly advance with the use of VBA and SQL commands.
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...
ASKER
Thanks for your update.
I usually follow your instructions when creating ODBC connections to an SQL server.
"External data-->Import-->More--->OD BC
...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?
I usually follow your instructions when creating ODBC connections to an SQL server.
"External data-->Import-->More--->OD
...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?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
;-)
http://www.qodbc.com/qodbc.htm
install, configure, ... then in Access simply click
External data-->Import-->More--->OD
...to connect to the QB data (tables)