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
Converting .XLS Format file to .csv
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
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.
It's not something that you would sensibly expect DataStage to be able to do.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
pls check the below link:
http://www.ibm.com/developerworks/forum ... D=13829337
(or)
http://www.andykhan.com/jexcelapi/
http://www.ibm.com/developerworks/forum ... D=13829337
(or)
http://www.andykhan.com/jexcelapi/