Install Microsoft Excel Driver (*.xls *.xlsx *.xlsm *.xlsb)
Informatica can read the Microsoft Excel source as a relational database. 
We can ODBC connection to the Excel file to import each worksheet as a table.
Install Microsoft Excel Driver (*.xls *.xlsx *.xlsm *.xlsb)
Probably 99% of all Excel workbooks are saved in the XLSX file type these days. But there are various other file extensions available: For example XLSM, XLSB or “older” Excel users might still remember the XLS file type. Connection Strings using Excel 2007 ODBC for connections to Excel, Excel 97, Excel 2000, Excel 2002, Excel 2003, Excel 2007, Excel 2010 and Excel 2013. Type ODBC Driver Usage Microsoft Excel Driver (*.xls, *.xlsx, *.xlsm, *.xlsb) More Info and driver downloads Articles read all » Jet for Access, Excel and Txt on 64 bit systems.
You do not need a username and password to import Microsoft Excel sources. This solution demonstrates steps to establish a connection to Excel ODBC and read data in a Informatica Developer mapping. The following tasks need to be completed before you import an Excel source definition. • Install the Microsoft Excel ODBC driver on the system. • Launch ODBC Administrator • If you are using a 32 - bit version of the Informatica Developer client • Go to C: Windows SysWOW64 and click on odbc32.exe application. • If you are using a 64 - bit version of the Informatica Developer client • Go to Control Panel All Control Panel Items Administrative Tools and click on Data Sources (ODBC) • Under System DSN, click on Add and select Microsoft Excel Driver (*. Xls, *.xlsm, *.xlsb, *.xlsx) • Click finish and provide Data source name for the ODBC Microsoft Excel setup. My name is khan.