ALERT: Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.

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.

book

Article ID: 20523

calendar_today

Updated On:

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