Excel Data

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
cherry
Participant
Posts: 108
Joined: Sun Jul 10, 2005 1:35 am

Excel Data

Post by cherry »

Hi All,

I have requirement to read the Excel data and load to a Oracle table.
Is there any stage in DS to read the excel data, If yes please let me know how I can achieve.


Thanks in Advance..


Best Regards
Cherry
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

Since you are on a Windows server, the ODBC stage is your man. I'd suggest searching for "ODBC Excel" as this has been discussed here in the past. A lot.
-craig

"You can never have too many knives" -- Logan Nine Fingers
Post Reply