How to get Excel CSV format in to write text cells in quotes?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Past versions of Excel would put quotes around the text cells in the
speadsheet when I would "Save As" in a CSV format. Office XP doesn't seem to
be able to do that. I have programs that use that format and would like to
know if I can change something to make this work.
 
Hi Jah,

When you export from Access it still puts the "" around any text so, if you
have it, try importing your spreadsheet into it and then export it out again.

It is not an ideal solution but a work-around if your upagainst a deadline.

Thanks,

Simon
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel CSV Files; Creating Of 3
How to Keep Excel Sheet Formatting On a CSV Sheet with vba 1
Quote Marks Question 2
CSV->Excel Data Problem 1
Excel And Notepad 3
Adding Quote Marks To A Very Long Column. How, Please ? 1
line break does not appear in CSV 3
CSV file doesn't save "xEy" style number as text formatted data 1

Back
Top