1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18
| Sub INSERTB2011()
Dim Db As DAO.Database
Dim strSQL As String
Dim derlign As Long, i As Long
'connexion à la base
Set Db = DAO.OpenDatabase("D:\Base\BaseP&L.mdb", False, False)
'
For i = 15 To 50
strSQL = "INSERT INTO IMPORTSAP2009 VALUES ('" & Range("ad" & i) & "', '" & Range("ac" & i) & "', '" & Range("z" & i) & "', '" & Range("aa" & i) & "', '" & Range("ab" & i) & "', '" & Range("ab" & i) & "', '" & Range("ab" & i) & "', '" & Range("ab" & i) & "', '" & Range("ab" & i) & "', '" & Range("ab" & i) & "', '" & Range("ab" & i) & "', '" & Range("ab" & i) & "', '" & Range("ab" & i) & "', '" & Range("ab" & i) & "', '" & Range("ab" & i) & "', # 01/01/2011 #, # 01/01/2011 #, " & Range("m" & i) & ", " & Range("m" & i) & ", " & Range("m" & i) & ")"
Db.Execute strSQL
Next i
'deconnexion de la base
Db.Close
End Sub |
Partager