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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Display weeks from a Milestone 0
Images are pixelated when saving to PDF 0
VBA - exporting serial letters to single documents 0
Automation of scanned file storage based on content 0
Default local file location - folder redirection slowness 0
Converting isse with Export in Outlook 0
Adding data to MS Access from csv file 0
Adding Network Trusted Location on MS O365 Word per Computer Registry Setting 1

Top