Exporting from Access to Excel Help

  • Thread starter Thread starter Scott
  • Start date Start date
S

Scott

I have a scheduling table that lists clients, locations,
and dates that a project will be worked on. Is there a
good way to export data from an Access database to fill in
the Client, Location, and Date cells in the excel file?
Thanks for the help.
 
If you just want to fill in the cells generically, use the
TransferSpreadsheet command (DoCmd.TransferSpreadsheet). If you want to
control where the values go (into specific cells), you'll need to use
Automation to open EXCEL file and directly write the data into a worksheet's
cells.
 
Back
Top