BulkCopy chokes on commas

[jbradley]

I'm using BulkCopy under program control from a VB6 program to import a comma-delimited text file. The problem I've run into is that occassionaly a field will contain a comma (as in a name that has been entered lastname, firstname) and this breaks the import process. I have no control over the raw data but I am building the delimited file, so I can do it any way I want. I know that Access recognizes the double-quote character as a text qualifier but BulkCopy and SQL seem to take everything between the delimiters as literal data.

Is there some character I can use as a text qualifier or will I have to choose a different delimiter than the comma, with the chance that whatever I use will appear within a field once in a while?

Thanks in advance...