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?
Adding Excel as one of the ODBC source in the odbc.ini file
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
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.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.