Reading from excel

leonardo2 · Post by **leonardo2** » Wed Aug 25, 2010 2:32 am

Can anybody tell me how to read a excel file from datastage

PhilHibbs · Post by **PhilHibbs** » Wed Aug 25, 2010 2:36 am

leonardo2 wrote:Can anybody tell me how to read a excel file from datastage

On a Unix server? Not sure if it's possible. On a Windows server, you can use ODBC and set it up as a data source.

sultan@cts · Post by **sultan@cts** » Wed Aug 25, 2010 2:37 am

leonardo2 wrote:Can anybody tell me how to read a excel file from datastage

Conver the Excel sheet to .csv file and use sequential file stage to read the same.

HariK · Post by **HariK** » Wed Aug 25, 2010 3:57 am

if the excel file has more than one sheet than converting to CSV will not work.

ray.wurlod · Post by **ray.wurlod** » Wed Aug 25, 2010 4:01 am

Find a UNIX-based ODBC driver for Microsoft Excel and use that.

chulett · Post by **chulett** » Wed Aug 25, 2010 6:31 am

HariK wrote:if the excel file has more than one sheet than converting to CSV will not work.

Sure it will, it just means you end up with more than one csv file.

DSXchange