Solved

Link Access to Quickbooks

Posted on 2012-04-03
5
653 Views
Last Modified: 2012-04-03
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.
0
Comment
Question by:RDLFC
  • 4
5 Comments
 
LVL 74

Expert Comment

by:Jeffrey Coachman
ID: 37801596
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
 
LVL 74

Expert Comment

by:Jeffrey Coachman
ID: 37801623
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
 

Author Comment

by:RDLFC
ID: 37801698
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
 
LVL 74

Accepted Solution

by:
Jeffrey Coachman earned 500 total points
ID: 37802106
All of this info is on their FAQ page:
http://qodbc.com/support.htm
0
 
LVL 74

Expert Comment

by:Jeffrey Coachman
ID: 37802977
;-)
0

Featured Post

Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Overview: This article:       (a) explains one principle method to cross-reference invoice items in Quickbooks®       (b) explores the reasons one might need to cross-reference invoice items       (c) provides a sample process for creating a M…
Describes a method of obtaining an object variable to an already running instance of Microsoft Access so that it can be controlled via automation.
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
Using Microsoft Access, learn some simple rules for how to construct tables in a relational database. Split up all multi-value fields into single values: Split up fields that belong to other things into separate tables: Make sure that all record…

863 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

23 Experts available now in Live!

Get 1:1 Help Now