.CSV Files

My csv file is delimited by commas and text is delimited by ". My file
considers carriage returns and next line characters enclosed in " as
text. I am facing a problem when trying to open this file in excel.
The excel doesn't care that next line character enclosed by " and
thinks it is the end of a record. Is there a way to excel that
anything inside " should be treated as text?

Thanks in advance

.

Relevant Pages

  • Re: How do I allow blank columns in a .CSV file?
    ... I am using the csv file to upload data from excel to a website - the website ... "Dave Peterson" wrote: ... not buying much by making sure that there are extra commas in the file. ...
    (microsoft.public.excel.misc)
  • Re: problems parsing CSV file
    ... Excel is different again. ... irregularity in the CSV file. ... >My first guess was that there was a comma, quote mark or carriage return ... >of these records and which ones piggyback and which ones don't. ...
    (microsoft.public.access.externaldata)
  • Re: Cant seem to use FileSystemObject
    ... csv file with fields that contain commas themselves isn't in csv ... the way to import a text file is TransferText; in Excel ... I need a procedure to import a csv file created by a third party ... referenced the Microsoft Scripting Runtime library, ...
    (comp.databases.ms-access)
  • Re: Excel should warn about commas when saving .csv files.
    ... Excel will put double quotes around fields with embedded commas. ... If you open a CSV file, excel will be smart enough to know that you're in one ... This post is a suggestion for Microsoft, ...
    (microsoft.public.excel.misc)
  • Re: How to save text as CSV which also contains commas?
    ... Excel will include double quotes round the contents of such ... and when importing the csv file it will treat the double quotes as ... what about if I want to see the data as an excel sheet. ... Extra commas ...
    (microsoft.public.excel.misc)