ETL and Data Integration tools - Modern ETL software for everyone

How can I import an Excel file that has a password assigned to it?

Thanks,
Kelly

You may try using DSN-Less connection

Driver={Microsoft Excel Driver (*.xls)};DriverId=790;Dbq=C:\MyExcel.xls;DefaultDir=c:\mypath;Uid=Admin;Pwd=yourpassword;

eg:
create a new odbc connection
Put amended string into DSN edit box
Leave user name and password blank

John

When I create a new ODBC connection and in the server box I type in any connection string I always get the same error response of
\"SQLDriverConnectFailed: IM002[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified.\"

I tried the Excel string starting with
Driver=;DriverId=790;Dbq=D:\MIS\...

And I tried a SQL string starting with
Driver={SQL Native Client};Server=wcdc;Database=...

I tried other drivers also and keep getting the same error.

Am I doing something wrong?

Thanks.

just tested it myself in Visual Importer and Advanced ETL Processor

Worked fine for me

Driver={SQL Native Client};Server=test;Database=demo;uid=sa;pwd=xx

Driver={Microsoft Excel Driver (*.xls)};DriverId=790;Dbq=C:\\test_data_source.xls;DefaultDir=c:\\;


But I do not think it is possible to open password protected Excel file at all

the driver itself does not support it

support.microsoft.com/?KBID=211378

Peter

I installed the software on another server and tried using the ODBC string and it worked. I took the same exact ODBC string and tried it back on the first server and it does not work. The same string. (I used cut and paste just to be sure.) At this point I do not know if it is the server or the software installation.

Thanks,
Kelly

May be the first server is 64 bit and you have not got 32 bit's drivers installed.

It is not straight forward on 64 bit platforms

John