[RESOLVED] How to save a xls file as csv via ADO ?

[jj2007]

Well maybe you can tell us what "correctly" handling CRLF within a column value should look like?

As far as I know, common CSV doesn't address the matter and it is just illegal.

Yes and no: CrLf should simply be treated as a new row; technically you could wrap it in quotes, but I doubt you would find something like that in the wild.

However, you can find embedded linefeeds e.g. in an official UN database available here - starting with footnote 456, Source: Dominican Republic Encuesta Nacional de Hogares..., approximately row 41174, there are 34 of them. I write "approximately" because Excel 2003 doesn't load them correctly.

Which brings me to a few questions - if they are stupid, apologies:

If there is no Office installation on a machine, is it still possible to load an Excel file in format *.xls or *.xlsx via ADO or JET?
If yes, are these applications part of a standard Windows installation?
If so, why does Microsoft allow everybody to open their proprietary formats?