Posted to microsoft.public.excel.programming

Simon[_2_] Simon[_2_] is offline

external usenet poster

Posts: 89

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

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

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Text Qualifiers	Wavequation	Excel Discussion (Misc queries)	1	June 3rd 10 08:44 PM
How do I remove text qualifiers from imported data?	Gail Baker	Excel Discussion (Misc queries)	0	October 26th 06 05:51 PM
Exporting to CSV without text qualifiers	Centurius	Excel Programming	4	September 18th 06 03:27 AM
Saving as a csv file with text qualifiers	Rajendra Pai	Excel Discussion (Misc queries)	2	January 18th 05 07:45 PM
How to parse a csv string with text qualifiers	Janelle	Excel Programming	16	October 8th 04 08:00 PM

All times are GMT +1. The time now is 10:15 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us