1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24
|
For i = 1 To NbTables
Var = 2
While Cells(Var, i).Value <> ""
For j = 1 To NbPays
MySql = "SELECT " & Table(i) & ".[" & Cells(Var, i).Value & "] FROM " & Table(i) & " WHERE (" & Table(i) & ".Pays)='" & Pays(j) & "' ORDER BY " & Table(i) & ".Pays, " & Table(i) & ".Année; "
Nom_Pays(NbVar) = Pays(j)
NbVar = NbVar + 1
'affiche le contenu de la requete sur la base base_jumbo.mdb
ColExcel = ColExcel + 1
With ActiveSheet.QueryTables.Add(Connection:=Array( _
"OLEDB;Provider=Microsoft.Jet.OLEDB.4.0;" _
& "Data Source=" & Application.ActiveWorkbook.Path & "/base_1.mdb"), _
Destination:=Cells(1, ColExcel))
.CommandType = xlCmdSql
.CommandText = MySql
.Refresh
End With
Next j
Var = Var + 1
Wend
Next i
appAccess.Quit
Set appAccess = Nothing |
Partager