Access and QuickBooks

[Scarlet59]

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

 

[Daniel Pineault]

Goto to Quickbooks website and download the SDK kit for your vesion of QB
then start coding away. They give sample code to inspire yourself from.

http://developer.intuit.com/technical_resources/default.aspx?id=1488
--
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.

 

[Scarlet59]

Thank you Daniel, I will try that.
Barbara

Goto to Quickbooks website and download the SDK kit for your vesion of QB
then start coding away. They give sample code to inspire yourself from.

http://developer.intuit.com/technical_resources/default.aspx?id=1488
--
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.

 

[Arvin Meyer [MVP]]

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

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.

 

[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

 

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

 

[Arvin Meyer [MVP]]

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.

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,

 

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

 

[james]

hssb