Page 1 of 1
Reading from excel
Posted: Wed Aug 25, 2010 2:32 am
by leonardo2
Can anybody tell me how to read a excel file from datastage
Re: Reading from excel
Posted: Wed Aug 25, 2010 2:36 am
by PhilHibbs
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.
Re: Reading from excel
Posted: Wed Aug 25, 2010 2:37 am
by sultan@cts
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.
Re: Reading from excel
Posted: Wed Aug 25, 2010 3:57 am
by HariK
if the excel file has more than one sheet than converting to CSV will not work.
Posted: Wed Aug 25, 2010 4:01 am
by ray.wurlod
Find a UNIX-based ODBC driver for Microsoft Excel and use that.
Re: Reading from excel
Posted: Wed Aug 25, 2010 6:31 am
by chulett
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.