Adding Excel as one of the ODBC source in the odbc.ini file

[pradkumar]

Hi

For Text fiel as the Data Source, we have the following configuration in our odbc.ini file
[Text]
Driver=/apps/applmgr/Ascential/DataStage/branded_odbc/lib/VMtxt20.so
Description=DataDirect 5.00 TextFile(*.*)
AllowUpdateAndDelete=0
ApplicationUsingThreads=1
CacheSize=4
CenturyBoundary=20
Database=/scratch/DataDirect_5.0/odbc/demo
DataFileExtension=TXT
DecimalSymbol=.
Delimiter=
FileOpenCache=0
FirstLineNames=0
IntlSort=0
ScanRows=25
TableType=Comma
UndefinedTable=GUESS


I would like to add Excel Data Source as one of the ODBC sources in the odbc.ini file.
Could any of you let me know the process of doing it?

[ray.wurlod]

Do you have an ODBC driver for Excel? None ships with DataStage - you will have to obtain a third-party driver from somewhere. When you get that, read its documentation as to the location and name of its driver library, and construct your .odbc.ini entries from that.