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 35 36 37 38 39
| Dim oApp As Excel.Application
Dim oWkb As Excel.Workbook
Dim oWSht As Excel.Worksheet
Dim derLigne As Long
Dim i As Long
Dim CheminFile As String
Dim mavar1 As String, mavar2 As String, mavar3 As Long, mavar4 As String, mavar5 As Date
Call OpenFile("S:\")
CheminFile = Dialogue.lpstrFile
Set oApp = CreateObject("Excel.Application")
Set oWkb = oApp.Workbooks.Open(CheminFile)
Set oWSht = oWkb.Worksheets(1) 'ouvre le premier onglet
'Désactive les messages lors de l'ajout
DoCmd.SetWarnings False
'Cherche la dernière ligne de la colonne B
derLigne = oWSht.Range("B65536").End(xlUp).Row
For i = 3 To derLigne
mavar1 = oWSht.Cells(i, 2).Value
mavar2 = oWSht.Cells(i, 3).Value
mavar2 = SupprimeEsp(mavar2)
mavar3 = oWSht.Cells(i, 4).Value
mavar4 = oWSht.Cells(i, 5).Value
mavar5 = oWSht.Cells(i, 6).Value
DoCmd.RunSQL "INSERT INTO tbl_Rib_Transmis([T3SE- identabonne],[T3SE- argument],[EN-N],[T3SE- code],[T3SE- date creation service])VALUES(mavar1, mavar2,mavar3,mavar4,mavar5)"
Next i
DoCmd.SetWarnings True
oWkb.Close savechanges:=False
oApp.Quit
Set oApp = Nothing
Set oWkb = Nothing
Set oWSht = Nothing |
Partager