1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23
|
Private Sub Exporter_Click()
Dim nomFic As String
Dim qd As QueryDef
Dim exist As Boolean
nomFic = InputBox("Saisissez le nom du fichier", "Exportation de la table [table]")
For Each qd In CurrentDb.QueryDefs
'export_table est le nom de la requete qui te permet d'exporter ta requete sous excel
If qd.Name = "export_table" Then
DoCmd.DeleteObject acQuery, "export_table"
exist = True
End If
Next
Set qd = CurrentDb.CreateQueryDef("export_table", "select * from [table]")
DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel97, "export_table", "cheminRépertoire" + nomFic +".xls"
'ouverture de la requete
DoCmd.OpenQuery "export_table"
End Sub |
Partager