16,555
社区成员
发帖
与我相关
我的任务
分享
Dim con As New OleDb.OleDbConnection
con.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Application.StartupPath & "\TemPlate\ShuXingbiao1.xls;Extended Properties='Excel 8.0;HDR=no;IMEX=1'"
con.Open()
Dim constr As String = "insert into [Sheet1$](F1, F2) values ('111', 'ABC')"
Dim cmd As New OleDb.OleDbCommand(constr, con)
'cmd.CommandText = "insert into [Sheet1$](F1, F2) values ('111', 'ABC')"
cmd.ExecuteNonQuery()
提示的错误还是一样的