Install Microsoft Excel Driver (*.xls *.xlsx *.xlsm *.xlsb)
Remember the first day beyonce free mp3 download. • Open ODBC Administrator 64-bit: C: Windows System32 odbcad32.exe 32-bit: C: Windows SysWOW64 odbcad32.exe • Go to System DSN > Add. • Select the Access/Excel driver and click Finish. • Enter the Data Source Name, select the Access/Excel file and click OK.
Install Microsoft Excel Driver (*.xls *.xlsx *.xlsm *.xlsb)
I'm having a problem with the ODBC connection that is supposed to connect to an Excel table and do stuff with it. I've already read a lot stuff on the internet about.
• On PowerCenter client machine, open Workflow Manager, create a new Relational Connection of type ODBC. Specify the Name, dummy User Name and Password. The Connect String should be same as the name of Excel/Access DSN you created in previous step. Informatica Server and Microsoft Office are installed on different machines In this case, you need to install Microsoft Access Database Engine on Informatica Server machine.