How to export different table to different sheet of 1 excel file

  • Thread starter Thread starter Guest
  • Start date Start date
If you export a table or query to an existing EXCEL file using
TransferSpreadsheet (macro or VBA), and the first 31 characters of the table
or query do not match the name of any existing worksheet in that EXCEL file,
ACCESS will create a new worksheet in that file.
 
Back
Top