Page 1 of 1

How to read excel file in Datastage

Posted: Tue Apr 13, 2010 11:42 pm
by anand_dafaria
Hi All,

I am facing problems while reading excel file in Datastage Px in Unix environment.

I have tried doing it using sequential file stage, but it is not able to read the data.
If am I converting it into csv file (manually) then I am able to do read it.
But we will be getting pleanty of such source files. So can not do it manually.

My questions are ---
1. Can we read Excel files in Datastage on Unix platform?
2. If no, then how to convert excel files into Csv format in Datastage.

Can anyone help me...

Regards
Anand

Posted: Wed Apr 14, 2010 12:30 am
by ray.wurlod
Doesn't the DSXchange Search facility work for you?

This question has been asked, and answered, on more than a few occasions.