Please how do I export Multiple table at once to one Excel sheet from my ACCESS dBase using VBA or any other available means.....? I have used different codes and it did not work. Please help me out.

1. In case of 9 tables to 1 spreadsheet in 1 workbook:
It depend on the structure of your 9 tables. If they are same structure, you can do it easier.

2. In case of 9 tables to 9 spreadsheet in 1 workbook:
If the structure of 9 tables in access in difference. VBA is easy to do

Please clarify your requirement.

If the tables are all the same format, create a union query and export the union query.

Although - having 9 tables in the same format does sound like a design flaw but that's a different problem.

Thanks all. The tables have the same format, with same fields. Only the fields hold information for different groups. the required information in similar, but from different set of people.  E.G. in a secondary school settings, each of these classes have a no. of pupil, and all their information in similar throughout. Now, their information are all in different tables, I want to get out all the students information into one excel worksheet, with just a click. This is the case!

I will appreciate your helpful contributions! Thanks

Based on that comment, you should review some database design articles.  Everything belongs in a single table rather than 9 separate tables.  Having 9 tables makes 9 times the work for you due to having to create extra forms/reports/queries, etc.

Thanks, but since the table hold similar information for different groups I think it's ok, because individual table is been updated on a daily bases. I have also created forms for each, where the update takes place, the issue is just to export all of them at once to excel by clicking a tab. Please find the attached file
DBASE-STUDENTS.accdb

There is a good example.