Can Access upload to Quickbooks?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

AHawley - 16 Aug 2005 21:41 GMT

I would like to design an Access database that would allow me to enter data
and upload some of that data into QuickBooks to generate invoices for
customers and order forms for vendors.

Reply to this Message

Douglas J. Steele - 16 Aug 2005 22:18 GMT

Take a look at http://www.qodbc.com/default.htm (or do a Google on
+quickbooks +odbc for other alternatives)

Once you've got a DSN set up, you should be able to write to QuickBooks as
though it were any other table in your database.

Signature

Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)

>I would like to design an Access database that would allow me to enter data
> and upload some of that data into QuickBooks to generate invoices for
> customers and order forms for vendors.

Reply to this Message

Kevin Nelson - 24 Aug 2005 17:56 GMT

I have been working in a similar, if not the exact same, thing for
about a week now and have not been able to figure out how to configure
Access to post SQL statements to QODBC. The idea is to have the
end-user input data into a table in Access and then have Access post
that data to an Invoice. I have seen their tutorial for saving new
records/creaing a multiline invoice, and it was not very helpful to me.

Any more insight would be greatly appreciated.

> Take a look at http://www.qodbc.com/default.htm (or do a Google on
> +quickbooks +odbc for other alternatives)
[quoted text clipped - 10 lines]
> > and upload some of that data into QuickBooks to generate invoices for
> > customers and order forms for vendors.

Reply to this Message