Converting .XLS Format file to .csv

Rakesh311 · Post by **Rakesh311** » Wed Jun 08, 2011 9:55 pm

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

ray.wurlod · Post by **ray.wurlod** » Thu Jun 09, 2011 5:07 am

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.

Rakesh311 · Post by **Rakesh311** » Thu Jun 09, 2011 10:36 pm

thanks Ray,

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

kmsekhar · Post by **kmsekhar** » Thu Jun 09, 2011 11:48 pm

pls check the below link:

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