Hi,
For me the input source is an excel file. How can I read that xls file in a job?
Can anyone please help?
Thanks
How to read a xls file
Moderators: chulett, rschirm, roy
Please use search next time as recommended, this subject is covered at least once a month. Check out this thread for example.
-
- Participant
- Posts: 6
- Joined: Sun Mar 09, 2008 2:31 am
Re: How to read a xls file
Convert excel sheet in text file using below steps.xch2005 wrote:Hi,
For me the input source is an excel file. How can I read that xls file in a job?
Can anyone please help?
Thanks
step1: Open the excel sheet
step2: Save the Excel sheet by giving file name(XXXXX) and
Save as Type: Text(Tab Delimited)).
step3: Sequential stage and extract the data.
if you have any queries, mail to me samala.madhu@gmail.com
Last edited by samala.madhu@gmail.com on Fri Jul 25, 2008 11:22 am, edited 1 time in total.
-
- Premium Member
- Posts: 783
- Joined: Mon Jan 16, 2006 10:17 pm
- Location: Sydney, Australia
Hi samala,
and if you can prevent the loading of Excel-Files: DO IT.
Excel is such a good and flexible calculation tool, that you need a 100 % dicipline from your users. If you only have 99.9999999999999999 % you are lost, errors will occur and don't blame DataStage for that, it is the excel nature.
Use MS-Access or other similar tools for User-Input. Otherwise you will need a lot of time for the loading process, due to it.
and if you can prevent the loading of Excel-Files: DO IT.
Excel is such a good and flexible calculation tool, that you need a 100 % dicipline from your users. If you only have 99.9999999999999999 % you are lost, errors will occur and don't blame DataStage for that, it is the excel nature.
Use MS-Access or other similar tools for User-Input. Otherwise you will need a lot of time for the loading process, due to it.
Wolfgang Hürter
Amsterdam
Amsterdam
Workaround - xls now converted to csv file
Had the xls file converted to a csv file and now it is resolved.WoMaWil wrote:Hi samala,
and if you can prevent the loading of Excel-Files: DO IT.
Excel is such a good and flexible calculation tool, that you need a 100 % dicipline from your users. If you only have 99.9999999999999999 % you are lost, errors will occur and don't blame DataStage for that, it is the excel nature.
Use MS-Access or other similar tools for User-Input. Otherwise you will need a lot of time for the loading process, due to it.
Thanks all for your time and reply.
Thanks