|
楼主 |
发表于 2015-7-9 16:28
|
显示全部楼层
[广告] Excel易用宝 - 提升Excel的操作效率 · Excel / WPS表格插件 ★ 免费下载 ★ ★ 使用帮助★
Public Sub 数据录入()
Dim SQL As String
On Error Resume Next
Set cnn = CreateObject("adodb.connection")
cnn.Open "Provider=Microsoft.Jet.Oledb.4.0;Data Source=" & ThisWorkbook.Path & "\Access 数据库.mdb;"
Arr = Range("D4:H11")
For n = 2 To 8
SQL = "INSERT INTO [项目记录表] (序号,项目, 数量, 单价, 金额) Values(" & Arr(n, 1) & ",'" & Arr(n, 2) & "'"
For i = 3 To 5
SQL = SQL & "," & Arr(n, i)
Next
SQL = SQL & ")"
cnn.Execute SQL
Next
cnn.Close: Set cnn = Nothing
End Sub
|
|