In ADT, the ODBC MS Excel Driver cannot be seen, if ADT and MS Excel are used on a 64-bit version of Windows 2008.

Products

• Advantage Data Transformer

Issue/Introduction

Description:

In ADT, the ODBC MS Excel Driver cannot be seen, if ADT and MS Excel are used on a 64-bit version of Windows 2008.

The customer attempts to connect their ADT instance to an ODBC source utilizing the MS Excel Driver. They follow the instructions below until they get toStep 3 C.

There is no listing for the ODBC MS Excel Driver displayed. They can see the ODBC driver configured in the ODBC System DSN, but it does not show up in ADTMapper ODBC Scanner.

Solution:

Refer to the Microsoft Document http://support.microsoft.com/kb/2721825/EN-US. This will give instructions on how to make Excel visible in a 32-bit application like ADT.

Environment

Release:
Component: DWM