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.
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.