How to export all tables from an Access Database into Excel - A sheet for each table

Viewed 36922

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?

3 Answers
Related