Quickbooks integration

[Mark Andrews]

I'm going to add one way quickbooks integration to one of my Access 2007
databases so transactions can be exported out
of my database and imported into Quickbooks. This is a new area for me
but was thinking of allowing the users to basically click a button to make
an INF file which could be imported into quickbooks.

This is a commercial product so I have no control over the users and their
environment.

Wondering if anyone else has been down this path and would have some advice.

Not looking for just a link to the quickbooks website or quickbooks ODBC
drivers, more
of "this is how I did it, or this is what I would recommend type of answer".

Thanks in advance,
Mark

 

[Daniel Pineault]

Sadly, I cannot give you code, as it is proprietary to my client, but here is
the basic method that I used.

No need to create an intemediate file, as you can connect and interact
directly with QB.

Go on their website and down load the appropriate SDK file for your version
of QB. Form their, they have example for different action. You will then be
able to use the QB reference library and connect directly to QB and do
whatever you wish.

Be foreworned, the initial connect is slow. Dead slow compared to other
connections (excel, word,...). Once the connection is establish, the action
are processed at a decent speed, but initially, one can think something is
wrong.

I will see if my client mind me disclosing code and will post back if he
agrees with some specifics.
--
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.

 

[deko]

Sounds great. I could make use of that code.

Sadly, I cannot give you code, as it is proprietary to my client, but here is
the basic method that I used.

No need to create an intemediate file, as you can connect and interact
directly with QB.

Go on their website and down load the appropriate SDK file for your version
of QB.  Form their, they have example for different action.  You willthen be
able to use the QB reference library and connect directly to QB and do
whatever you wish.

Be foreworned, the initial connect is slow.  Dead slow compared to other
connections (excel, word,...).  Once the connection is establish, the action
are processed at a decent speed, but initially, one can think something is
wrong.

I will see if my client mind me disclosing code and will post back if he
agrees with some specifics.
--
Hope this helps,

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

 

[De Jager]

I'm going to add one way quickbooks integration to one of my Access 2007
databases so transactions can be exported out
of my database and imported into Quickbooks. This is a new area for me
but was thinking of allowing the users to basically click a button to make
an INF file which could be imported into quickbooks.

This is a commercial product so I have no control over the users and their
environment.

Wondering if anyone else has been down this path and would have some
advice.

Not looking for just a link to the quickbooks website or quickbooks ODBC
drivers, more
of "this is how I did it, or this is what I would recommend type of
answer".

Thanks in advance,
Mark

 

[Mark Andrews]

Daniel,

Thanks for the advice. I would love to see the code you used! I'll keep my
fingers crossed. I'll sign an NDA if needed.

Even if you can't give me the code would you have advice on what versions
would be easy to support. I need to make this
integration generic because different clients might have different versions
of QB.

Thanks,
Mark