Run-time error:'-2147217887(80040e21)': ODBC driver does not support the requested proper

please let me know i am stuck here

Please Login or Register  to view this content.

connection string

strConn = "Provider=MSDASQL.1;Password=bmx1;Persist Security Info=True;User ID=root;Data Source=mysql32;Initial Catalog=wds"

his still showing the same error

Are you trying to connect to a MySQL database?

i am trying to update excel sheet data to mysql database tablename(tblprod_agr_006)

Have you downloaded and installed a MySQL driver? If so, which one?

yes its ODBC Driver

Which one? From where?

5.3 for mysql website

I suspect that your connection string should be more like:

Please Login or Register  to view this content.

You're currently using what looks like an MSSQL connection string

Driver=MySQL ODBC 5.2 Unicode Driver;SERVER=192.168.1.200;UID=root;data source=mysql32;PWD=bmx1;DATABASE=wds;PORT=3306;Initial Catalog=wds

Eh? Do I take it that you've got it working now then?

Run-time error '3265':

item cannot be found in the collection corresponding to the requested name or ordinal.

Please Login or Register  to view this content.

I think you mean:

Please Login or Register  to view this content.

right rs(ActiveSheet.Cells(2, i).ID) = ActiveSheet.Cells(j, i)

What? Just posting random code doesn't really help here. What are you asking?

i am getting error there while executing the code

You haven't changed it to my suggestion:

Please Login or Register  to view this content.

thanks for helping it showing successful update but it is still not changing the values in mysqldatabase to a particular table(tblprod_agr_006)

Please Login or Register  to view this content.

I'd do it with building a SQL string and run multiple update statements. Try that and see if it works

ok........

now my program is working now but it is not updating last row why? let me know please