.CSV Files

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

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: Save as CSV not saving the same from Excel 2007 then in Excel 2003
    ... I can confirm that xl 2003 saves blank rows as blank rows while xl2007 saves them with commas and seems to add a few rows at the end ... Microsoft Excel MVP ... "Craig" wrote in message ... blank rows from Excel show up as about 15 commas on the CSV file. ...
    (microsoft.public.excel.misc)
  • 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)