How to export Access data to Quickbook?

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.

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



"Paul" wrote in message
...
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.

Thank you Peter. The information contains in the link is really helpful.

Thanks

"Pete D." wrote in message
...
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



"Paul" wrote in message
...
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.

On Tue, 1 Jan 2008 11:04:36 -0800, "Paul" wrote:

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.

Glad I could help, Pete D
"Paul" wrote in message
...
Thank you Peter. The information contains in the link is really helpful.

Thanks

"Pete D." wrote in message
...
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



"Paul" wrote in message
...
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.