Importing data from 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
ravij
Premium Member
Premium Member
Posts: 170
Joined: Mon Oct 10, 2005 7:04 am
Location: India

Importing data from Excel file

Post by ravij »

Hi,

How to import data from excel file to table.?

Thanks in advance
Ravi
Top
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:
Contact ray.wurlod

Post by ray.wurlod »

Searching the forum will yield at least three solutions.

An Excel worksheet is a table, as presented by the Excel ODBC driver.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Top
ashwin141
Participant
Posts: 95
Joined: Wed Aug 24, 2005 2:26 am
Location: London, UK

Importing data from Excel file

Post by ashwin141 »

Hi Ravi

You can convert the excel file to a CSV and FTP the CSV file to a file path on the UNIX then read the file.

Regards
Ashwin
Top
Post Reply

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