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
picking data from excel sheet and load data into excelsheet
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 48
- Joined: Thu May 05, 2005 9:24 pm
-
- Charter Member
- Posts: 130
- Joined: Mon Sep 06, 2004 3:05 am
- Location: Dubai,UAE
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
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
Warm Regards,
Amruta Bandekar
<b>If A equals success, then the formula is: A = X + Y + Z, X is work. Y is play. Z is keep your mouth shut. </b>
--Albert Einstein
Amruta Bandekar
<b>If A equals success, then the formula is: A = X + Y + Z, X is work. Y is play. Z is keep your mouth shut. </b>
--Albert Einstein