exporting data to Excel

[Guest]

I need to write some code that would allow me to export to an excel
spreadsheet...taking from an access table some fields to update some
particular cells in the Excel sheet.
Where can I get some good examples????
Thanks so much!

 

[Guest]

try this one:

DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel9, "Mytable",
"C:/Myexprtedfile.xls"

let me know if this doesn't work.

Restu Kresnadi