Page 1 of 1

How can I read an Excel file as a source?

Posted: Fri Mar 25, 2005 11:50 am
by sdpaeth
I'm running DataStage 7.5 on SunOS and have a requirement to read an excel file as a source.

Can this be accomplished through vanilla Datastage or do I have to find a third party product or ODBC driver ?

Posted: Fri Mar 25, 2005 12:46 pm
by kab123
This topic is covered earlier..
you have options either to use ODBC or save the excel file as csv or any text format and use Sequential file Stage..
Search thru the forum and you will get the answers...

Posted: Fri Mar 25, 2005 12:48 pm
by sdpaeth
Who's ODBC Driver do you recommend ?

DataStage does not ship with a Driver that reads Excel Docs.