Reagrding xls file as source in Datastage Job

kirankumarreddydesireddy · Thu Jan 27, 2011 11:11 pm

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

Ravi.K · Post by **Ravi.K** » Thu Jan 27, 2011 11:24 pm

Create DSN Entry by taking the XLS drivers pointing to the file and Use ODBC stage.

ray.wurlod · Post by **ray.wurlod** » Thu Jan 27, 2011 11:34 pm

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.