Exporting into Quickbooks

  • Thread starter Thread starter Rico
  • Start date Start date
R

Rico

Hello,

I have a client that wants me to build him a custom application in Access.
One of the requirements is that he either exports from Access and imports
into Quickbooks or just pushes information directly into Quickbooks.

I've never done this before and I was wondering if there are any
difficulties involved or if there is "an easy way" that this can be done?
Hopefully someone here can enlighten me with their own experience, but
actually, any direction would be greatly appreciated.

Rick
 
Hello,

I have a client that wants me to build him a custom application in Access.
One of the requirements is that he either exports from Access and imports
into Quickbooks or just pushes information directly into Quickbooks.

I've never done this before and I was wondering if there are any
difficulties involved or if there is "an easy way" that this can be done?
Hopefully someone here can enlighten me with their own experience, but
actually, any direction would be greatly appreciated.

Rick
Click to expand...

Rico,

This is a shot in the dark, but if you can't use the API created by
Quickbooks for that purpose, you might be able to export some tables
from Quickbooks into something like CSV or Excel files. Once you know
the field names and structure of the tables, you can create your own
import tables from Access that should import correctly. Note that you
would have to test that method out thoroughly because some Quickbooks
tables might be related to other Quickbooks tables.

James A. Fortune
(e-mail address removed)
 
I have looked into this myself, but not done anything about it.
The quickbook tables and relationships can be got from the quickbooks
website.

I know of an access mvp who advertises on his company website that they do
work with databases exporting to and from quickbooks - at the going rates.
If you want the company details, let me know.



Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia
 
It is actually very easy to interact with Quickbooks! Sadly, however, it is
equally extremely slow and painfull to do.

Goto the Quickbooks website and download the SDK for the version you are
going to be working with. The SDK comes with PDF/HTML references and
examples. You should have no problem from there. Also, their forum is a
good place to look for examples and ask your own questions.

Depending on which approach you adopt, you may need to install the QBFC or
QBXMLRP installers on your computer as well as your clients PC when you
deliver the final product.
--
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.
 
Jeanette,

If your offer is good for anyone, I'll take the mvp's name/website?
I might decide to pay someone to add this functionality to a few programs.

send it to (e-mail address removed)
remove the ___NOSPAM___

Thanks,
Mark
 
That's an excellent start, thanks all for your input! Mark, I will let you
know if I can find anything else!

Thanks again!

Rick
 
Thanks and good luck!
Mark

Rico said:
That's an excellent start, thanks all for your input! Mark, I will let
you know if I can find anything else!

Thanks again!

Rick
Click to expand...
 
Back
Top