export des données

vision globale ici : http://cafeine.developpez.com/access/tutoriel/excel/

Table ou requete vers Excel

DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel97, "Table ou Requête ACCESS a transférer", "Chemin du fichier EXCEL", , "Nom de la Feuille EXCEL (que pour l'import ?)"

Exporter les résultats d'une zone de liste lors par exemple une recherche multicritères

Dim SQL As String SQL = Me!lstResults.RowSource CurrentDb.CreateQueryDef "resultats", SQL DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel9, "resultats", txtChemin, True DoCmd.DeleteObject acQuery, "resultats"

OutputTo : objets de la base vers un format xl, pdf, etc ...

DoCmd.outputto ObjectType, ObjectName, OutputFormat, Output file, Autostart, Templatefile, encoding,

ObjectType – acOutputTable( to output table), acOutputquery(to output query),acoutputreport(to output report),ascendform(to output form), acOutputModule(to output module)

ObjectName – Name of table, query, Report etc.

OutputFormat – acFormatHTML ,acFormatRTF ,acFormatSNP,acFormatTXT ,acFormatXLS, acFormatXLSX , acFormatPDF , etc.

Output file – Complete path of output file eg. C:\abc.xls or d:\abc.pdf Keep it blank if you want to save at run time.

AutoStart Optional Variant

Templatefile – The full name, including the path, of the file to use as a template for an HTML file

Encoding- Optional Variant

If you are facing any problem in export access report to excel visit the below linkhttp://support.microsoft.com/kb/934833

‘ EXAMPLE 1 EXPORT form TO xls FORMAT

Sub send_form_to_xls_using_docmd_outputto()

DoCmd.OutputTo acOutputForm, “sales_detail”, acFormatXLS, , True

End Sub