picking data from excel sheet and load data into excelsheet

kalyanvinnakota · Post by **kalyanvinnakota** » Mon Feb 13, 2006 10:37 pm

Hi all,

Could any one help me how can we pick the data from an Excel sheet and load the data to an Excel sheet using data stage.

Thanks in advance

regards
Kalyan

rasi · Post by **rasi** » Mon Feb 13, 2006 11:02 pm

Hi Kalyan

do a search on Excel there are heaps of post related to read excel sheets using datastage.

Regards

Sunshine2323 · Post by **Sunshine2323** » Tue Feb 14, 2006 12:18 am

Hi Kalyan,

Since you are working on UNIX platform you cannot read directly from excel you have to change the excel sheets to csv and then do the loading.

Also already suggested Search on keywords 'Excel' and 'UNIX' will give you tons of info.

Check this post for more info