Access and QuickBooks

S

Scarlet59

Does anyone know if you can export date to Quickbooks from Access 2007 and
reverse?
Thanks,Barb
 
S

Scarlet59

A

Arvin Meyer [MVP]

Scarlet59 said:
Does anyone know if you can export date to Quickbooks from Access 2007 and
reverse?
Thanks,Barb
Click to expand...

QuickBooks does link with some databases using an ODBC driver:

http://www.qodbc.com/qodbc.htm

The earlier versions that I used were very slow, and expensive $200. for
each version. They also don't allow interaction with some tables.

QuickBooks does have an SDK, but you cannot program Access compatibility
with it as it uses C, C++, or C#, not VB or VBA. So you would need to be
able to program C or C++ COM objects to make it work with Access.
 
S

Scarlet59

Arvin,
That sounds great. I'm not sure about having to write codes to get a program
to work. This looks much easier.
Thanks
 
D

Daniel Pineault

Arvin,

It feels wierd correcting you of all people (as I am usually asking you for
help), but the SDK does indeed permit vba coding with Quickbooks. I have
sucessfully used it in Excel and Access now. Perhaps the older versions did
not, but the current SDK does permit vba integration/programming. Add the
proper references to your project and you're off the the races (as they say).

The process can be slow however, but does work.
--
Hope this helps,

Daniel Pineault
http://www.cardaconsultants.com/
For Access Tips and Examples: http://www.devhut.net
Please rate this post using the vote buttons if it was helpful.
 
A

Arvin Meyer [MVP]

Daniel Pineault said:
Arvin,

It feels wierd correcting you of all people (as I am usually asking you
for
help), but the SDK does indeed permit vba coding with Quickbooks. I have
sucessfully used it in Excel and Access now. Perhaps the older versions
did
not, but the current SDK does permit vba integration/programming. Add the
proper references to your project and you're off the the races (as they
say).

The process can be slow however, but does work.
Click to expand...

Hey, my wife corrects me constantly <g>

Thanks for the correction. I was going by what I saw on their website. The
older versions only allowed C or C++ (not even C#) and didn't really even
have an SDK when I tried working with it last time.

When you say slow, do you mean painfully slow? It was when I used the ODBC
connector. I seem to remember a query taking about 35 seconds to return 18
rows from a table with a little over 700 rows. In Access, that would be
measured in microseconds.

Thanks,
 
D

Daniel Pineault

Sadly, the speed issue remains. It is 'painfully slow'! but it does work.
Sending info to QB is done at an acceptable speed. Ie transfering db data to
QB to create a new client or invoice...., but retrieving QB info is
rediculously slow.

I need to query QB to pull item listings and tax codes and you might as well
go grab a coffee and come back before it will have completed the query.
--
Hope this helps,

Daniel Pineault
http://www.cardaconsultants.com/
For Access Tips and Examples: http://www.devhut.net
Please rate this post using the vote buttons if it was helpful.
 
Top