Exporting into Quickbooks

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
 
J

James A. Fortune

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

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

Mark Andrews

J

Jeanette Cunningham

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
 
D

Daniel Pineault

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

Mark Andrews

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
 
R

Rico

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
 
M

Mark Andrews

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top