creating odbc connection

[#1]

Hi All,

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

thanks regards,

KC

[kiranmanoharrode]

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

[#3]

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

[agomes1971]

Hi,

see this...

How use OLEDB to connect to XLSM (excel file)?

HTH

André Gomes

[#5]

[peter_turner]

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);