Exporting from Access to Excel Help

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.
 
K

Ken Snell

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.
 
Top