could datastage able to read a excel file

Post questions here relative to DataStage Server Edition for such areas as Server job design, DS Basic, Routines, Job Sequences, etc.

Moderators: chulett, rschirm, roy

Post Reply
rajiivnb
Participant
Posts: 77
Joined: Fri Sep 10, 2004 8:38 am
Location: India

could datastage able to read a excel file

Post by rajiivnb »

Hi ,
My source is a excel file .Is there any stage to read the excel file.How sud i go about reading excel file.
thanks in advance

Regards,
Rajii
Top
kcbland
Participant
Posts: 5208
Joined: Wed Jan 15, 2003 8:56 am
Location: Lutz, FL
Contact:
Contact kcbland

Post by kcbland »

Setup a system DSN using MS supplied ODBC driver to Excel file. Search the forum for the issues you will encounter.
Kenneth Bland

Rank: Sempai
Belt: First degree black
Fight name: Captain Hook
Signature knockout: right upper cut followed by left hook
Signature submission: Crucifix combined with leg triangle
Top
rajiivnb
Participant
Posts: 77
Joined: Fri Sep 10, 2004 8:38 am
Location: India

Post by rajiivnb »

Hi Kenneth,
Thank you.

Regards,
rajii
Top
Post Reply

Return to “IBM<sup>®</sup> Infosphere DataStage Server Edition”