I have an Access database with ~30 tables.
How can I export all 30 tables into separate sheets in an Excel workbook?
I'm hoping to find some VBA/VBS code which I can run from within Access to accomplish this task.
Any ideas?
I have an Access database with ~30 tables.
How can I export all 30 tables into separate sheets in an Excel workbook?
I'm hoping to find some VBA/VBS code which I can run from within Access to accomplish this task.
Any ideas?