How to read a xls file

[xch2005]

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

[ArndW]

Please use search next time as recommended, this subject is covered at least once a month. Check out this thread for example.

[samala.madhu@gmail.com]

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

Convert excel sheet in text file using below steps.

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

[keshav0307]

samala.
you can do it for onetime, but not good advice for scheduled job.
it's commonly asked question here. so search will help you

[WoMaWil]

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.

[xch2005]

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.

Had the xls file converted to a csv file and now it is resolved.
Thanks all for your time and reply.

Thanks