Can I export all the tables as an excel workbook?
How can I export all the tables of my database into one excel workbook with each worksheet equals to one table?
You can't directly. You'd have to export each table as a separate file. I suspect, however, that once you have exported the data, you might be able to use a Macro in your Excel workbook to pull the data all into one file.
Retrieving data ...