Exporting to CSV Problem

[JesseM3]

I'm trying to export a set of data using ASP/VBscript into a CSV file so that it can be read as a spreadsheet in Excel. The problem is that some of the fields themselves (it's being created by a loop that goes through a set of data retrieved from a database) have commas in them, so they are read as delimiting rather than just being part of the what should be entered in a cell.

Any clue how to get it to ignore those commas?

 

[Bastien]

try to place single quotes around the data...why not export directly to XL? Bastien

There are many ways to skin this cat,
but it still tastes like chicken