很简单,用ADODB, dim db as New ADODB.Connection dim rs as New ADODB.Recordset dim cmd as New ADODB.Commanddb.ConnectionString = "xxxxxxxxxxx" '懒得写,看看ODBC的吧,windows本身的帮助就有 db.Openset cmd.ActiveConnection = dbcmd.CommandText = "Insert Into YourTableName (ColumnName1,ColumnName2, .....) Values (Value1,Value2, .....)" set rs = cmd.execute最简单的就是这样了,详细的语法自己研究研究吧,反正总的来说就是:cmd.CommandText = "标准的SQL语法" set rs = cmd.Execute每次一个SQL语句
dim db as New ADODB.Connection
dim rs as New ADODB.Recordset
dim cmd as New ADODB.Commanddb.ConnectionString = "xxxxxxxxxxx" '懒得写,看看ODBC的吧,windows本身的帮助就有
db.Openset cmd.ActiveConnection = dbcmd.CommandText = "Insert Into YourTableName (ColumnName1,ColumnName2, .....) Values (Value1,Value2, .....)"
set rs = cmd.execute最简单的就是这样了,详细的语法自己研究研究吧,反正总的来说就是:cmd.CommandText = "标准的SQL语法"
set rs = cmd.Execute每次一个SQL语句