>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

What is inverted comma? single/double quotes? If so they don't have a problem if you pass them as parameters instead of literally typing (if you do use double ie: O''hara)
Cetin