How to export Access data to Quickbook?

  • Thread starter Thread starter Paul
  • Start date Start date
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.
 
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.
 
Back
Top