Export data from an excel sheet to a text file

[tornadoproggie]

HEy I would be grateful if somebody could help me. I have to feed in data to a mySQL database on my host server. MY client has given me the data in an excel sheet. Is there any way to export this data into a text file by specifying the row and column delimiters. I need it in this format cos the database can take data frm a formatted text file.

 

[MiggyD]

File>Save AS>(change extension to CVS or TXT accordingly)>SAVE (button)

 

[csr]

I am jumping into this thread because I am having all sorts of difficulties with this seemingly, simple process.
I wish to save an Excel Worksheet to a comma delimited text file with Double quotes around each record.

I have attempted what was described above .... selected CSV, tried TXT (MS-DOS), etc ...

I get questions about format not supported, do you wish to keep format, re-save in different excel format, ... it asked me if I wish to save it twice ... and finally, the final file does not have double quotes around all of the fields ... Only puts them there if the field contains a comma ....

So, the bottom line is that I am not finding it to be as simple as you might think. Anyone have some insight into why this seems so difficult ?

Don
dond@csrinc.com