exporting data to Excel

  • Thread starter Thread starter Guest
  • Start date Start date
G

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!
 
try this one:

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

let me know if this doesn't work.

Restu Kresnadi
 
Back
Top