Excel data source

[#1]

Hi all

How can I convert a bounch of same format Excel spreadsheets into qlikview

data source like .qvd?

I am a starter of qlikview, forgive my silliness.

thanks

Gloria

[Anonymous · Accepted solution]

Hi Gloria,

It's fine to use Excel files as data sources.

If you want to load a table from a number of Excel files, with the same structure, in a folder you can use a load statement like:

Load

     Field1,

     Field2,

     etc.

From Path\*.xls;

If you're new to QlikView, try using the load data from "Table Files..." button in the script editor to pull in one of the Excel files and then you can just replace the filename in the script with a * after you have gone through the steps of the load wizard.

[#3]

I am trying it now, thanks so much~~