Export multiple tables to Excel

  • Thread starter Thread starter Kay Ree
  • Start date Start date
K

Kay Ree

Does anybody have any code on how to export multiple
tables from an Access database to Excel? Say I have 50
tables in an Access database, how do I do a multi export
to Excel. I know I can do it using a Macro
TransferSpreadsheet but am not familiar with VBA. Any code
to help me do it would be much appreciated. Thank you!
 
Back
Top