1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23
| Sub Importer_par_requête()
Dim StartTime As Double
Dim MinutesElapsed As String
StartTime = Timer
strSQL = "SELECT F1 AS DEPT, F17 AS DEP_MAR, F18 AS DEP_FEV, F19 AS DEP_JAN, F20 AS DEP_DEC, F21 AS DEP_NOV, " & _
"F22 AS DEP_OCT, F23 AS DEP_SEP, F24 AS DEP_AOU, F25 AS DEP_JUL, F26 AS DEP_JUN, F27 AS DEP_MAI, F28 AS DEP_AVR, " & _
"F41 AS BUD_MAR, F42 AS BUD_FEV, F43 AS BUD_JAN, F44 AS BUD_DEC, F45 AS BUD_NOV, F46 AS BUD_OCT, F47 AS BUD_SEP, " & _
"F48 AS BUD_AOU, F49 AS BUD_JUL, F50 AS BUD_JUN, F51 AS BUD_MAI, F52 AS BUD_AVR, F57 AS BUD_LAST_YR " & _
"INTO MyNewTable " & _
"FROM [Excel 8.0;HDR=No;database=F:\donnees financiers 2013-2014.xlsm;].[DOWNLOAD$A8:BE57285];"
Set qdfNew = CurrentDb.CreateQueryDef("ImporterExcel", strSQL)
DoCmd.OpenQuery "ImporterExcel"
MinutesElapsed = Format((Timer - StartTime) / 86400, "hh:mm:ss")
MsgBox "Importation réussie en " & MinutesElapsed & " minutes", vbInformation
End Sub |
Partager