Link to home
Start Free TrialLog in
Avatar of ALABI ADEWALE
ALABI ADEWALE

asked on

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.

I already build a dBase, but I want to be pooling some report from the Access dbase to Excel. What I want to do is to export 9 tables all at once to one Excel sheet, which will already be designated in the document of the System. How do I do this?
Avatar of OddyWriter
OddyWriter
Flag of Thailand image

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.
Avatar of PatHartman
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.
Avatar of ALABI ADEWALE
ALABI ADEWALE

ASKER

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
ASKER CERTIFIED SOLUTION
Avatar of PatHartman
PatHartman
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
There is a good example.