Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

Link Access to Quickbooks

Posted on 2012-04-03
5
Medium Priority
?
679 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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 2000 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

Nothing ever in the clear!

This technical paper will help you implement VMware’s VM encryption as well as implement Veeam encryption which together will achieve the nothing ever in the clear goal. If a bad guy steals VMs, backups or traffic they get nothing.

Question has a verified solution.

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

This article describes two methods for creating a combo box that can be used to add new items to the row source -- one for simple lookup tables, and one for a more complex row source where the new item needs data for several fields.
Did you know that more than 4 billion data records have been recorded as lost or stolen since 2013? It was a staggering number brought to our attention during last week’s ManageEngine webinar, where attendees received a comprehensive look at the ma…
Basics of query design. Shows you how to construct a simple query by adding tables, perform joins, defining output columns, perform sorting, and apply criteria.
In Microsoft Access, learn the trick to repeating sub-report headings at the top of each page. The problem with sub-reports and headings: Add a dummy group to the sub report using the expression =1: Set the “Repeat Section” property of the dummy…

636 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