How do I export a datasheet back to an Excel table

excel| Backup | data
How do I export a datasheet back to an Excel table
Author: cg1 Excerpt from: access911.net
Problem:

How do I export a datasheet back to an Excel table
Reply:
Note: You can not only export the data from the table to Excel files, but also export the results of the query to Excel files.
For example, paste the following statement into NORTHWIND. In the MDB module, you can export the results of the "aggregate sales by Year" query to C:\A.XLS in this EXCEL file.
The reason for this is to demonstrate an export query rather than an export table because the query can be the result of a table filtered by some criteria.
Function Exporteg ()
Docmd.transferspreadsheet Acexport, AcSpreadsheetTypeExcel9, "Summary of sales by year", "C:\a.xls", True
End Function



Take a look at the following example:
Docmd.transferspreadsheet Acexport, AcSpreadsheetTypeExcel9, "Table_juan", strFilePath, True, "Juan"


strFilePath is the path to XLS file, such as: Strfilepath= "C:\a.xls"

Table_juan is the name of the table in the database
Juan is the name of sheet in the XLS file.