Reading from excel
Moderators: chulett, rschirm, roy
Reading from excel
Can anybody tell me how to read a excel file from datastage
-
- Premium Member
- Posts: 1044
- Joined: Wed Sep 29, 2004 3:30 am
- Location: Nottingham, UK
- Contact:
Re: Reading from excel
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.leonardo2 wrote:Can anybody tell me how to read a excel file from datastage
Phil Hibbs | Capgemini
Technical Consultant
Technical Consultant
-
- Participant
- Posts: 31
- Joined: Thu Jul 05, 2007 11:57 pm
- Location: India
- Contact:
Re: Reading from excel
Conver the Excel sheet to .csv file and use sequential file stage to read the same.leonardo2 wrote:Can anybody tell me how to read a excel file from datastage
Thanks
Sultan
Sultan
Re: Reading from excel
if the excel file has more than one sheet than converting to CSV will not work.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Re: Reading from excel
Sure it will, it just means you end up with more than one csv file.HariK wrote:if the excel file has more than one sheet than converting to CSV will not work.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers