Can MS Access and Quickbooks exchange data?

[Craig Armitage]

I would like to get my database to create a new invoice or receipt in
quickbooks for a given job. Is it possible to make a button on an access
form that sends data over to quickbooks?

Thanks guys

 

[aaron.kempf]

nope. MDB is obsolete and it shouldn't be used for anything; anywhere.

MDB has capacity / scalability problems with a single record and a
single user

get a real ETL tool like SQL Server DTS or SSIS

-Aaron

 

[Arvin Meyer [MVP]]

You can exchange data with Quickbooks, but you will need an ODBC driver and
all data is not writeable. I have used this driver and found it very slow and
somewhat expensive ($200). There is a newer version which I haven't as yet
tried.

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

I've also found this one, but I haven't used it and can't comment other than
to say the price is attractive ($40 to $50):

http://www.bigredconsulting.com/aboutdatalink.htm
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads
http://www.datastrat.com
http://www.mvps.org/access

 

[Larry Linson]

... you will need an ODBC driver and all data is
not writeable. I have used this driver and found
it very slow and somewhat expensive ($200).
There is a newer version which I haven't as yet
tried.

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

To add to your comments, within the past year, I was investigating this. I
found the site you reference to have very detailed descriptions of the
QuickBooks tables, and the full "Pro-version" QODBC driver, in a
time-limited trial version, was available for download.

I didn't do enough with it to offer any observations on speed.

Larry Linson
Microsoft Access MVP