Hi
I have a requirement to read from excel file(.xls file).Can anyone please let me know how to do this Datastage job and which stage to use.
I think we can do it in ODBC stage but I am not sure.
Thanks
Kiran
Reagrding xls file as source in Datastage Job
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 110
- Joined: Mon Jan 11, 2010 4:22 am
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Yes, the ODBC stage is the correct one.
A couple of tips ("gotchas"):
(1) Excel worksheets are presented by the driver as system tables so, when importing table definitions, you must check the "include system tables" box.
(2) Worksheet must be in columnar form with column headings.
(3) You must use a System DSN or File DSN; it does not work with User DSN.
(4) The default in the driver is "read only". You have to change this if you want to be able to write to Excel.
(5) There is one DSN per workbook.
A couple of tips ("gotchas"):
(1) Excel worksheets are presented by the driver as system tables so, when importing table definitions, you must check the "include system tables" box.
(2) Worksheet must be in columnar form with column headings.
(3) You must use a System DSN or File DSN; it does not work with User DSN.
(4) The default in the driver is "read only". You have to change this if you want to be able to write to Excel.
(5) There is one DSN per workbook.
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.