using #Print to send records to CSV file (1 Viewer)

[accessuser1023]

all,

I'm using this function and I'm concatenating all of the field data from the Excel spreadsheet into one string that represents a record. However, some of the field data actually *contains* commas! So my record string would look like this:

value1,value,2,value3,value4

So using #Print in VBA doesn't work because by 'CSV definition' the values would not go fall into the fields properly (one value per field) because of the commas inside the values themselves. Using the data above, I would get this in the output file:

value1 | value | 2 | value3 | value4

but what I really want is:

value1 | value,2 | value3 | value4

Is there anyway around this that anyone knows about? I'm thinking I'll have to write data cell by cell in every record, but I have since forgotten how to do this.

Any help out there? thanks!