Monday, April 20, 2009

Import Excel data into QuickBooks

With QImport4 you can also import Excel spreadsheet data into QuickBooks.

The way to do it is as follows:
In QImport from the menus open Utilities | Create SQL Connection
As connection string enter:
Provider=Microsoft.Jet.OLEDB.4.0;Data Source=;Extended Properties="Excel 8.0;HDR=Yes;IMEX=1";

As SQL statement enter:
Select * from [$]
Save the connection.
When you create a new template then chose the saved .qsql file as import file.

Example:
Connection String:
Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\spreadsheet.xls;Extended Properties="Excel 8.0;HDR=Yes;IMEX=1";

SQL Statement:
Select * from [Sheet1$]

That's it.

No comments:

Post a Comment