How to Export All Tables to Excel Workbook (1 Viewer)

Hi is it possible to export my tables to Excel in the same workbook but each table on a different tab? Also can it maintain the same column headers?


Thank you,
Bill

Yes, I'm sure it could be done!

I recently did something very similar for a member here, see my notes on my website:-

https://www.niftyaccess.com/access-table-to-many-excel-sheets/

There's a link to the code that I used to do this, it should be relatively easy to adapt it to your purposes I reckon.

I believe it was Bob Larson who developed the code. He was a regular contributor and well respected member here, who has now retired I believe.

Sent from my Pixel 3a using Tapatalk

Thanks Uncle Gizmo I will give it a try.