DSXchange

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?

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.