thanks for the replies.

I will tidy up the sql statement but first I want
to make a successful connection with ADO
I copied and pasted the code and
got an automation error, unspecified error -2147467259(80004005).
I have narrowed it down to the line
oRS.Open sSQL, oConn, adOpenStatic, adLockOptimistic
which seems to be causing the error?

I would like to what the disadvantages and advantages
are between using ODBC and ADO. It's not really clear to me
if you use one or the other or if ADO is used in conjunction
with ODBC.

Also, I would like to know if there are some references with
use ADO and mysql.

thanks very much

--
Message posted from http://www.ExcelForum.com