1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34
| Public Sub exportation()
Dim Db As DAO.Database
Dim TWB As Object
Dim strSQL As String
Dim varA, varB, varC, varD, varE, varF, varG, varH, varI, varJ, varK, varL, varM, varN As String
Dim i, lastcell As Integer
lastcell = Range("N1").End(xlDown).Row
Set TWB = ThisWorkbook.Sheets("Feuil1")
Set Db = DAO.OpenDatabase("C:\dossier\dataBase.mdb", False, False)
For i = 2 To lastcell
varA = TWB.Range("A" & i): varB = TWB.Range("B" & i)
varC = TWB.Range("C" & i): varD = TWB.Range("D" & i)
varE = TWB.Range("E" & i): varF = TWB.Range("F" & i)
varG = TWB.Range("G" & i): varH = TWB.Range("H" & i)
varI = TWB.Range("I" & i): varJ = TWB.Range("J" & i)
varK = TWB.Range("K" & i): varL = TWB.Range("L" & i)
varM = TWB.Range("M" & i): varN = TWB.Range("N" & i)
strSQL = "INSERT INTO [Table1] VALUES('" & varA & "','" & varB & "','" & varC & _
"','" & varD & "','" & varE & "','" & varF & "','" & varG & "','" & varH & "','" & varI & _
"','" & varJ & "','" & varK & "','" & varL & "','" & varM & "','" & varN & "')"
Db.Execute strSQL
Next
Db.Close
End Sub |
Partager