1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18
| Sub ImportRequetedansExcel()
Datasource="C:\conso\BD.accdb"
StrSQL = "SELECT TauxParDate.Date, TauxParDate.TauxCC, TauxParDate.TauxCM " & _
"FROM (ListeDevises INNER JOIN TauxParDate ON ListeDevises.CodeBDF = TauxParDate.CodeBDF) INNER JOIN ListeSocietes ON TauxParDate.CodeBDF = ListeSocietes.Devise " & _
"WHERE ListeSocietes.NumSté = '" & strSociete & "'" & _
"ORDER BY TauxParDate.Date DESC"
strConnexion = "OLEDB;Provider=Microsoft.ACE.OLEDB.16.0;" & "Data Source=" & datasource & ";password=TEST"
Sheets("donnees").Select
With ActiveSheet.QueryTables. _
Add(Connection:=strConnexion, _
Destination:=Range("A1"), Sql:=StrSQL)
.SavePassword = True
.Refresh
End With
End Sub |
Partager