topic Re: ODBC Connection failed in QlikView

ODBC Connection failed

elakkians — Tue, 30 Jun 2015 13:47:49 GMT

Hi All,

I am trying to upload multiple excel files to the app

i am using this connection string

OLEDB CONNECT32 To [Excel Files;DBQ=$(vFileMG)];

but i am getting an error.

ErrorSource: Microsoft OLE DB Provider for ODBC Drivers, ErrorMsg: [Microsoft][ODBC Driver Manager] Invalid argument value

Could any plz explain me what is the problem .

Thanks,

Chanty4u — Tue, 30 Jun 2015 15:26:52 GMT

hi,

can u attach the screen shot for that

by that we come to =know where you exactly struk..

Thank you

Suresh

alexandros17 — Tue, 30 Jun 2015 15:27:22 GMT

You do not need any DB connection to load xls files ...

Chanty4u — Tue, 30 Jun 2015 15:33:10 GMT

you can use * symbol like ('*.xls')

you can laod all the xls files with out using db connection.

Thank you

elakkians — Wed, 01 Jul 2015 05:13:05 GMT

elakkians — Wed, 01 Jul 2015 05:59:48 GMT

you are right but i also need to take multiples sheets from multiple files ..

so nly i am using this ..