Hello all,
May be this is a silly one,but I am just wondering how to convert an .xls file to .csv format using DSPXversion.
Thanks in advance
convert from .xls to .csv
Moderators: chulett, rschirm, roy
convert from .xls to .csv
Thanx&Regards
scorpion
scorpion
Re: convert from .xls to .csv
Hi,scorpion wrote:Hello all,
May be this is a silly one,but I am just wondering how to convert an .xls file to .csv format using DSPXversion.
Thanks in advance
Open new excel sheet
Block all the cells (ctrl a)
left click with mouse Format cells->select Text-> copy the data from the excel and paste it on that sheet ->save -> select option as type (csv) in the drop down
give the extension as .csv
Regards
Naveen.K
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Do you have an ODBC driver for Excel on your DataStage server? If so, use that to read the worksheet and you can save the rows however you wish.
Last edited by ray.wurlod on Wed Aug 27, 2008 3:20 pm, edited 1 time in total.
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.