Quotes (inverted commas) will give you a problem. Replace them with two single quote marks ('', not "). I've not seen a problem with commas.
>So from your experience, it won't make much difference either ODBC or ADO...
>May be we can consider the ODBC and SPT path to speed up the conversion process.
>But are there known issues for ODBC.
>I've encountered problems with commas and inverted commas contained in strings when using SPT, how are these to be handled properly via ODBC?
>Yau
Craig Berntson
MCSD, Microsoft .Net MVP, Grape City Community Influencer