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