convert from .xls to .csv

[scorpion]

Hello all,

May be this is a silly one,but I am just wondering how to convert an .xls file to .csv format using DSPXversion.

Thanks in advance

[naveen19]

Hello all,

May be this is a silly one,but I am just wondering how to convert an .xls file to .csv format using DSPXversion.

Thanks in advance

Hi,

Open new excel sheet
Block all the cells (ctrl a)
left click with mouse Format cells->select Text-> copy the data from the excel and paste it on that sheet ->save -> select option as type (csv) in the drop down
give the extension as .csv

Regards
Naveen.K

[scorpion]

Thanks for the reply Naveen,

But I am looking to get this done through datastage px.

Any ideas..

[ray.wurlod]

Do you have an ODBC driver for Excel on your DataStage server? If so, use that to read the worksheet and you can save the rows however you wish.

[chulett]

In other words, do you have a UNIX ODBC driver for Excel that your company has purchased? DataStage does not ship with one.