Error while loading excel file?

[#1]

Hi,

Can anyone help me with below error please?

thanks.

[its_anandrjs]

What is the error message.

[#3]

Please see attached in my original post and help me please.

[alexandros17]

Why do you load xlsx file with odbc???

You may load directly ....

[amit_saini · Accepted solution]

Hi Ameila,

Make sure you have required driver installed and provide that driver and server name in connection string too like:

DRIVER={XXXX Driver V XXXX};Provider=msdaora;DSN=U500.WORLD;Uid=xyz;Pwd=123;SERVER=localhost;"

Thanks,

AS

[amit_saini]

Also I'm not sure why you are using ODBC connection for uploading excel sheet.????

Thanks,

AS

[its_anandrjs]

May be it is ODBC excel driver problem check this on the system where the driver available or try to recreate the ODBC connection for excel

//Connection

ODBC CONNECT TO [Excel Files;DBQ=D:\Qlikview\Sources\Creditor Meeting Split.xlsx];

[#8]

Hi Amelia,

You do not have to use an ODBC connection to load data from excel.

All you do is you click on the "Tables Files" button and then simply select your excel spreadsheet. You then select the sheet inside the excel spreadsheet that you want to use and you are ready to go.

Regards,
Marius

[#9]

Thanks. I agree. But I have a requirement to load through ODBC as I have 50 sheets data in workbook. I can bot make all 50 sheets in table files so I would prefer this. Would it possible to set tis please help.

[#10]

Do all of the sheets have the same data structure?

And what naming convention does the sheets have?

Maybe you can loop through one load and fetch data from all 50 sheets by using a variable, if the data structure is the same.