DSXchange

HI,

To read data from EXCEL File we have to option of creating DSN and converting to csv file.

Here I opted for the second one ie ,converting into .csv file.

Can you people guide me on how to do that other than manually converting?

Any batch script can be use for this requirement??

Thanks

Use Excel. Do it manually once, and record a macro. Now you will have VBA script that you can adapt.

It's not something that you would sensibly expect DataStage to be able to do.

thanks Ray,

I use the VS Script and call that by using the execute command...i felt its working fine..

pls check the below link:

http://www.ibm.com/developerworks/forum ... D=13829337
(or)
http://www.andykhan.com/jexcelapi/