How to export Access data to Quickbook?

P

Paul

I have an Access Invoicing system with several tables, Tbl_Customer,
Tbl_Sales and Tbl_Sales_Details, Tbl_Product, Tbl_Inventory, and I would
like to export/import the invoicing information to the QuickBook (currently
we are manually type in each transaction to the QuickBook with the hard copy
of the Customer Invoice from the Access Invoicing system). I did some
research on the export/import side on QuickBooks and it will accept the file
formats, IIF, CSV or using the QuickBook SDK. I am very confident in Access
development however I am very new to QuickBook. I am not sure which one of
the above three file formats would be most suitable. I know how to export
Access data to a CSV file, is it the best way to go? Where should I start
at? Is it one CSV file or multiple CSV files to import to QuickBooks? Where
can I find out the fields need to import to QuickBooks?

Where can I find step by step instructions on how to prepare export file
from an Access database and how to import to the Quickbook? Thanks.
 
P

Pete D.

This is really more of a quickbooks question but, search quickbook site and
the help file for IIF file import specs. Just make a query in access to
export to text file with iif extension in the format provided in the help
file. More details for one version are avaiable here.

http://www.ita-software.com/papers/QuickBooks.htm
 
P

Peter Hibbs

Paul

If you Google for :- QBPOS_ProgramGd_pdf you can download a 160
page Programmers Guide in pdf format for exporting data to Quick
Books. Whether you will be able to understand it is another matter, I
certainly didn't so don't ask me anything about it.

Peter Hibbs.
 

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