Saving .xls or .csv with text qualifiers (which Access and Oracleprovide)

S

Simon

When opening a .csv in Notepad you get any text fields with quotations
around them.

I would like to retain those quotations, storing the data in Excel.
(Excel currently either seperates the data into different columns or
puts it all in one column.

(Perhaps there is an automated cut/paste method from .txt files?)

How can I do it?

Thanks

Simon
 

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

Top