Exporting to Specific Excel Worksheet

  • Thread starter Thread starter alex richardson
  • Start date Start date
A

alex richardson

For Access exports to regularly update a specific
worksheet within an Excel spreadsheet, is there a way to
overlay the current worksheet rather than appending a new
worksheet?
 
Yes! That's what TransferSpreadsheet does, if you use the Range argument to
specify the worksheet name - although Access help says this argument is not
used in export.

Nikos
 
Back
Top