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 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55
| Sub Bouton45_Clic()
Feuil3.Range("AN4:AQ15000").ClearContents
'Option Explicit
Dim Cn As ADODB.Connection
Dim oCat As ADOX.Catalog
Dim Fichier As Variant
Dim Feuille As ADOX.Table
Dim Rst As ADODB.Recordset
Dim texte_SQL As String
Dim Ar() As String, i As Long
Fichier = Application.GetOpenFilename("Fichier Excel, *.csv;*.xls")
If Fichier = False Then Exit Sub
Set Cn = New ADODB.Connection
Set oCat = New ADOX.Catalog
Cn = "Driver={Microsoft Text Driver (*.txt; *.csv)};" & _
"Dbq=" & Fichier & ";Extensions=asc,csv,tab,txt"
Cn.Open
Set oCat.ActiveConnection = Cn
For Each Feuille In oCat.Tables
i = i + 1
ReDim Preserve Ar(i)
Ar(i) = Feuille.Name
Next Feuille
texte_SQL = "SELECT * FROM [" & Ar(1) & "]"
Set Rst = New ADODB.Recordset
Set Rst = Cn.Execute(texte_SQL)
Feuil3.Range("AN4").CopyFromRecordset Rst
Set Feuille = Nothing
Set oCat = Nothing
Cn.Close
Set Cn = Nothing
End Sub |
Partager