Excel data import

[#1]

I have data in excel and want to import in qlikview to generate chart for that.

how to do.

Thanks.

[Miguel_Angel_Baeyens · Accepted solution]

Hi,

Go to the script editor, then select Table Files... and follow the wizard to load the data right. That will create a script that will work every time you click on Reload.

Hope that helps.

Miguel

[#3]

Got one MDB source and had created the connection.but not getting the options how to load the tables from *mdb file to qlikview.

Please suggest some option

[Miguel_Angel_Baeyens]

Hi,

Prior to that, you need to create an ODBC using the "Connect" button in the script editor. If you already had done that, then use the button "Select" instead of the "Table file". There you will see a dialog with two main parts: the left one with the tables, views, etc, and the right one with the field names. Select and click on the "Add" button to generate the script.

You have got some free training and introduction to QlikView here.

Hope that helps.

Miguel