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

You might also look at this (and other) question:
http://www.qodbc.com/QODBCAutoFAQ.htm

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.

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?

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.

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?

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.

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

Even the VB Demo will not load invoices

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

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).