Buy Support
Incidents |
If you can't find your answer
in the FREE PUBLIC QDeveloper Forum, require URGENT Priority Support, or you need to send us
private or confidential information: |
Click Here
|
If you can't
login and post questions or you are having trouble viewing forum posts:
Click Here
|
Callback
Support |
If you live in USA, UK, Canada, Australia or New
Zealand, you can leave us details on your question and request us to call you back and discuss
them with you personally (charges apply). |
Click Here
|
Buy Support
Incidents |
If you can't find your answer
in the FREE PUBLIC QDeveloper Forum, require URGENT Priority Support, or you need to send us
private or confidential information: |
Click Here
|
|
access |
Author |
Message |
|
Posted : 2006-10-11 09:22:05 |
All I want to do is import some invoices into quickbooks from access. The access table is a download of the invoice file from another quickbook file.
Any simple way - I keep bombing out.
MIke |
|
|
|
Tom |
|
Group | : Administrator |
Posts | : 5510 |
Joined | : 2006-02-17 |
|
Profile |
|
Posted : 2006-10-11 14:20:06 |
The easiest method is to configure a Append Query to read the local mdb table and insert the result into QuickBooks. You need to use the invoiceline table... not the invoice table using the format:
INSERT INTO InvoiceLine SELECT FROM Invoicefile;
Search for "Create an append query (MDB)" in your MS Access help for further instructions.
See: How do I create Invoices? for what columns you need to use. |
|
|
|
|