topic Re: ODBC connection issue in QlikView

ODBC connection issue

vchuprina — Sat, 27 Feb 2016 22:08:43 GMT

Hi Guys,

I start working at new computer and have an issue with OBDC connection.

When I load files I get following issue "External table is not in the expected format".

Usually I use following code to make connection:

For Each vFile in FileList('$(vPath)\*xlsx')

ODBC CONNECT32 TO [Excel Files;DBQ=$(vFile)];

// Read list of sheets

Temp_Tables:

sqltables;

Also I installed ODBC driver from microsoft site, but problem still exist.

How can I solve this problem

Re: ODBC connection issue

petter — Sat, 27 Feb 2016 22:41:01 GMT

Are you sure that all the XLSX-files really are in XLSX-format? There could be corrupt files you know. Have you checked if this error message comes up with any or all of files?

Re: ODBC connection issue

swuehl — Sat, 27 Feb 2016 22:46:42 GMT

I assume you also created a User or System DSN using the ODBC Administrator (Edit script -> Tools -> ODBC Administrator xx Bit)?

Re: ODBC connection issue

vchuprina — Wed, 02 Mar 2016 11:41:38 GMT

Hi Petter,

I know such issue, so I check files and can confirm that all files are in xlsx format

Re: ODBC connection issue

vchuprina — Wed, 02 Mar 2016 11:43:39 GMT

Yes, I created DSN.

Re: ODBC connection issue

Joaquin_Lazaro — Wed, 02 Mar 2016 11:47:40 GMT

Hi VChuprina:

I don't use ODBC for importing excel files

XLS_File:

LOAD *

FROM

$(vDir)MyFile.xlsx

(ooxml, embedded labels);

Hope it helps,

Joaquín

Re: ODBC connection issue

petter — Wed, 02 Mar 2016 11:52:26 GMT

You haven't got a period between filename and extension, could that create a problem for you?

For Each vFile in FileList('$(vPath)\*xlsx')

Should be

For Each vFile in FileList('$(vPath)\*.xlsx')

Re: ODBC connection issue

Colin-Albert — Wed, 02 Mar 2016 12:05:07 GMT

It may help to add a trace command on $(vFile) so you can see what file is being processed in the logfile.

For Each vFile in FileList('$(vPath)\*.xlsx')

trace ......Processing $(vFile) ;

ODBC CONNECT32 TO [Excel Files;DBQ=$(vFile)];

// Read list of sheets

Temp_Tables:

sqltables;