Connecting Excel To Mysql Update PROBLEM

i am connecting to a mysql table through vba in excel and i am updating it: Set cn = New ADODB.Connection cn.Open 'DRIVER={MySQL ODBC 5.1 Driver};' & _ 'SERVER=localhost;'

Solution 1:

I'm not familiar with MySQL but TEXT looks like a blob type? If so I'm surprised it works at all as ADO requires special handling for BLOBS ( http://dev.mysql.com/tech-resources/articles/vb-blob-handling.html )

Try a VARCHAR type instead.

You could also try ADOCn.Execute "INSERT ..."