How to read data from password protected excel file with informatica

Question

Please help me to read data from a password protected excel file with informatica

Basically i need to convert excel to csv and read with informatica

Thanks

Answer 1

Excel is accessible using ODBC. So define a ODBC data source in the server (you would probably have to define a NAME in excel to delimitate the area you want imported).

Using (in Designer). Source->Import from database you can then create the Source and specify the password.