Install Microsoft Excel Driver (*.xls *.xlsx *.xlsm *.xlsb)
. 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. 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. Install 64-bit Microsoft Access Database Engine if Informatica Server is 64-bit. Install 32-bit Microsoft Access Database Engine if Informatica Server is 32-bit. For instance, if you are using a 64-bit Informatica Server, install 64-bit Microsoft Access Database Engine on Informatica Server machine.
This will install 64-bit version of Microsoft Excel Driver (.xls,.xlsx,.xlsm,.xlsb) and Microsoft Access Driver(.mdb,.accdb). All time low so wrong it right deluxe edition download. In addition, copy the Access/Excel file on the Informatica Server machine. Create 64-bit Access/Excel DSN using the driver and the copied file. Access driver provides an option to import files from a remote machine. You could download click the Download button, check AccessDatabaseEngine.exe/ AccessDatabaseEnginex64.exe accordingly, and then click Next. The bit version of Microsoft Office (which is installed on another machine) does not matter.
Informatica Server and Microsoft Office are installed on same machine but they are of different bit version. Informatica Server is 64-bit; however, Microsoft Office is 32-bit. In this case, as the installed Office is 32-bit, the 64-bit Access/Excel drivers will not be available and Microsoft does not support the side-by-side installation of 32-bit and 64-bit Microsoft Office or their dependent components. Therefore, if you attempt to install 64-bit Microsoft Access Database Engine 2010, it will fail with the following error.
There is a workaround for this, you could follow For more information on this, you could visit Microsoft forum, follow Import Access/Excel file in Designer If you do not have 32-bit Microsoft Office installed on the PowerCenter client machine, install 32-bit Microsoft Access Database Engine. To import Access/Excel table in Designer, create a 32-bit DSN.
Though 32-bit version of Microsoft Excel Driver(.xls) and Microsoft Access Driver(.mdb) are available on all Windows machines by default; however, they do not support all the extensions of Access and Excel files. For instance, you cannot import the.accdb file using Microsoft Access Driver(.mdb) OR.xlsx file using Microsoft Excel Driver(.xls). You also need the copy of Access/Excel file on client machine and need to select it while creating a DSN. Note You need to set custom property OptimizeODBCRead=No, otherwise the session fails with the following error in Domain logs.
Hi, I've tried everything I can think of and find online (see below) about this subject to no avail. My Windows 8.1 Surface Pro 3 does not have the.xlsx ODBC driver, even when I look it up in%windir% SysWOW64 odbcad32.exe. It only has the driver for.xls, which will eventually corrupt the.xls file used for the database after a few uses. On the Drivers tab in the ODBC Data Source Administrator, it says: 'To install new drivers, use the driver's setup program.' Where is this driver setup program and where can I download the.xlsx driver? Also, I just reformatted and started over again, re-installing Office 365 (includes Access) and everything else. It's a 64-bit Windows system and 32-bit Office.
Please advise! - I've already tried the advice listed in the links below without any success.
'When I attempt to create a new System DSN for an Excel 2010 Spreadsheet from within Impromptu, the above drive for the 'Create New Data Source' is unavailable. If I go to Control Panel/Administrative Tools/ Data Sources and attempt to create a System DSN, I have the above driver available. If I create a data source here, then, once I attempt to use it as a database for a new catalog in Impromptu, it is unavailable (it doesn't even show on the list of databases).
I am running Impromptu 7.5 on a Windows 7 64-bit installation. Any help would be greatly appreciated. This is working on another installation of the same version of Impromptu and Windows 7 with the difference being it is a 32-bit installation. Thank you for your time and assistance.'
I have missed this useful post ( what's a shame for me ).But it does not solve the problem of the many applications using Jet ( even if it is possible to change the driver and to use ODBC ) Even if it is very late, many thanks. A little reproach: it is impossible to have both 32-bit and 64-bit version on the same computer. To mitigage with your part The gotchas ( as it is written at the end of the post, it is possible that readers 'forget' to read this article upto the end, but it will be their problem ). I keep track of this post for the SQL Server Data Access Forum ( and because of that: THANKS ).