Dim smConnString As String
smConnString = "DRIVER={MySQL ODBC 3.51 Driver};SERVER=127.0.0.1;PORT=3306;DATABASE=dstore;USER=root;PASSWORD=111111;OPTION=3;"
Dim rs2 As New ADODB.Recordset
Dim connm As New ADODB.Connection
connm.Open smConnString rs2.Open "INSERT INTO fenzu (username, unit) VALUES('1', '1')", connm
Set rs2 = Nothing
Set connm = Nothing
smConnString = "DRIVER={MySQL ODBC 3.51 Driver};SERVER=127.0.0.1;PORT=3306;DATABASE=dstore;USER=root;PASSWORD=111111;OPTION=3;"
Dim rs2 As New ADODB.Recordset
Dim connm As New ADODB.Connection
connm.Open smConnString rs2.Open "INSERT INTO fenzu (username, unit) VALUES('1', '1')", connm
Set rs2 = Nothing
Set connm = Nothing
连接字符串参考:http://www.connectionstrings.com/
connm.execute "INSERT INTO fenzu (username, unit) VALUES('1', '1')"如果 unit是数值类型字段的话,SQL语句中的值不要用''号
connm.execute "INSERT INTO fenzu (username, unit) VALUES('1',1)"