OraFAQ Forum: Forms » HOW TO SAVE XLS to CSV?

Home » Developer & Programmer » Forms » HOW TO SAVE XLS to CSV?

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

HOW TO SAVE XLS to CSV? [message #181015]

Thu, 06 July 2006 05:23

wency
Messages: 450
Registered: April 2006
Location: Philippines

Senior Member

I have to make an XLS file as template in order to control cell format.I open the file using DDE package and input some data on it.The problem is I can't save the file on CSV format. I can only save it and not saveas(to CSV format).
What should I do?

[Updated on: Thu, 06 July 2006 05:24]

Report message to a moderator

Re: HOW TO SAVE XLS to CSV? [message #181115 is a reply to message #181015]

Thu, 06 July 2006 21:25

djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia

Senior Member
Account Moderator

Is there a MS Office command that will convert XLS to CSV?

David

Report message to a moderator

Re: HOW TO SAVE XLS to CSV? [message #181121 is a reply to message #181115]

Thu, 06 July 2006 22:43

lakshmi surya ram
Messages: 188
Registered: June 2006
Location: HYDERABAD

Senior Member

hi,

firstly transfer the data to xls file.

after you click f2 for saving the file,check for the csv(comma,delimted)and save it.now this stored in the respective module bin and check the back-hand table.

now the values will be populated over their.

regards,
surya

Report message to a moderator

Re: HOW TO SAVE XLS to CSV? [message #181130 is a reply to message #181015]

Fri, 07 July 2006 00:21

wency
Messages: 450
Registered: April 2006
Location: Philippines

Senior Member

F2?
I open the file in forms using DDE. Now I want to save it as xls file. I'm doing this because if I create a file using OLE2 I can't format the column, although I can save it directly as csv by changing the file extension.

Report message to a moderator

Re: HOW TO SAVE XLS to CSV? [message #181143 is a reply to message #181130]

Fri, 07 July 2006 01:08

djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia

Senior Member
Account Moderator

Think laterally. Instead of trying to put out a numeric fields with formatting, convert the number to a character field to which you have already applied the formatting.

HINT: Put a single quote as the first character of the field.

David

Report message to a moderator

Re: HOW TO SAVE XLS to CSV? [message #181156 is a reply to message #181143]

Fri, 07 July 2006 01:54

Maaher
Messages: 7065
Registered: December 2001

Senior Member

For a CSV, I'd use UTL_FILE. Besides, cell format? Since when can you actually format a CSV file apart from deciding what delimiter you use? I'm confused by your contradiction: a template to format a csv file in Excel? Perhaps I'm missing something here...

MHE

Report message to a moderator

Re: HOW TO SAVE XLS to CSV? [message #181165 is a reply to message #181015]

Fri, 07 July 2006 02:20

wency
Messages: 450
Registered: April 2006
Location: Philippines

Senior Member

Hi David!
I've already tried that for number. But what I pass date on MM/YYYY?

MHE,
I'l try to research on UTL_FILE.
Anyway, am I wrong of opening excel and saving it with CSV file extension? Delimeter in CSV is quite jargon to me?

tnx

Report message to a moderator

Re: HOW TO SAVE XLS to CSV? [message #182352 is a reply to message #181165]

Fri, 14 July 2006 07:51

djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia

Senior Member
Account Moderator

Sorry .. I don't do Excel. You will have to look in the Excel help and find the function that converts date fields to character fields.

David

Report message to a moderator

Previous Topic:	DBMS Error: FRM-40733
Next Topic:	how Handel the lov

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 20 12:28:28 CDT 2024