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?
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.