topic Re: creating odbc connection in QlikView

creating odbc connection

Mon, 12 Jan 2015 11:56:09 GMT

Hi All,

I would like to know how we can create odbc connection string and load multiple excel file???

thanks regards,

kiranmanoharrode — Mon, 12 Jan 2015 11:59:14 GMT

Hi Kapil,

There is no need of ODBC connection string for loading data from Multiple excel file...

Please explain your requirement in detail

Regards,

Kiran

Mon, 12 Jan 2015 12:02:44 GMT

sorry my mistake my question is how to load xlsm file in one coonection string?????

agomes1971 — Mon, 12 Jan 2015 12:15:52 GMT

Hi,

see this...

HTH

André Gomes

Mon, 12 Jan 2015 12:25:24 GMT

peter_turner — Mon, 12 Jan 2015 12:43:01 GMT

Hello Kapil,

Its also possible to load the XLSM straight into QV without an odbc connection.

In the script editor hit the 'table files' button and select your XLSM as normal.

If you need to load multiple files in that folder you could try adding a * into the filename such as

XLSM_Data:

LOAD *

FROM

[*.xlsm]

(ooxml, embedded labels, table is table1);