• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 515
  • Last Modified:

How do i export data from quickbooks to MS Access using QODBC

I have just purchased QODBC driver for quickbooks, and i am trying to export customer data from quickbooks to MS Access, but i do not know how to use the QODBC driver and am having great difficulty trying to figure it out. Does anyone know how to do this? A detailed walkthrough would be much appreciated!
0
ThomasEbeyer
Asked:
ThomasEbeyer
  • 6
  • 5
1 Solution
 
Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
You wouldn't really "export" data from QB, but you can build linked tables with the QODBC driver. Just click File - Get External Data - Link Tables, then build a DSN using the QODBC driver. You should then be able to select the tables you need from there.
0
 
Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
You might also look at this (and other) question:
http://www.qodbc.com/QODBCAutoFAQ.htm
0
 
Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
sorry, meant this one:

http://www.qdeveloper.com.au/forum.php?homeinclude=topicdetails&forum_id=1&category_id=1&post_id=110

HOwever, the link above is the home page for the FAQ for QODBC ... you'll need to reference that often while you're learning.
0
Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

 
ThomasEbeyerAuthor Commented:
Okay, i have done this but access is giving me the error message
"You cannot use ODBC to import from, export to, or link an external Microsoft Jet or ISAM database table to your database."
what does this mean and how do i fix it?
0
 
Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
You should only get this when you try to use ODBC to link to another Access database ... did you choose the correct driver (i.e. the QODBC driver) when you were linking? You'd also have to choose the correct database (i.e. the QB database) and your QB file would need to be opened, plus you'll have to make sure to allow Access to connect to QB.
0
 
ThomasEbeyerAuthor Commented:
okay yes i chose the wrong one, it is connecting as we speak. Now will this be updated as i enter new customers into quickbooks? if not is there anything i can do to make this possible?
0
 
Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
The "link" is a realtime link ... so if you enter data in QB, you should see it in Access. Note that you may have a bit of "lag" time between the time you enter QB data and the time you actually see it in your linked tables.
0
 
ThomasEbeyerAuthor Commented:
Im still having a problem, all my customer information seems to be working in real time, but when trying to connect invoices everything crashes. I need the Memos from these invoices to see what work was done for each customer.. i let it run for 15 mins and it still just says waiting for quickbooks 0 of 0
anywhere else i can find this data? I am using the optimization settings recomended on the qdeveloper.com site.. i dont want the application to need 20 mins to start up.. if this is going to start up atall
0
 
ThomasEbeyerAuthor Commented:
Even the VB Demo will not load invoices
0
 
ThomasEbeyerAuthor Commented:
Update - I have loaded the invoices, i just left it running, took a long time.. and thats not even where the correct memos are stored. In quickbooks, i can get to this information by creating a sales by customer detail report. Do you know what table i must import to find that information? I cant seem to find the correct one
0
 
Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
QB has a very odd structure; I use the SDK exclusively, and there are many areas that aren't yet exposed by the SDK (and QODBC is pretty much a wrapper around the SDK, so the limitations are there as well).
0

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

  • 6
  • 5
Tackle projects and never again get stuck behind a technical roadblock.
Join Now