Hi,
My question is:
I have an access database that has tables within it shows details like occupancy times and rooms. I would like to extract these tables from Access Database into Excel.
I have tried to find methods of extracting this but all I can find, is a method of extracting a single table at a time.
Is there a method of extracting all the tables from Access into Excel with each table being copied to a new sheet in the excel document?
Regards,
Stephen
This is some untested VBA to loop through the tables and export them to an excel workbook.
Not sure how to get them on separate sheets in the same workbook, but look at this link to see if it helps
Please Login or Register to view this content.
http://accessblog.net/2006/07/export...cel-range.html
EDIT: Just found this. https://stackoverflow.com/questions/...eet-for-each-t
Last edited by alansidman; 12-09-2018 at 10:19 PM.
Alan עַם יִשְׂרָאֵל חַי
Change an Ugly Report with Power Query
Database Normalization
Complete Guide to Power Query
Man's Mind Stretched to New Dimensions Never Returns to Its Original Form
This has been reported as Spam because of the advertising in the signature.
It may be that you are a genuine seeker of knowledge about Excel & Access. In which case welcome to the forum and would you remove the signature which is contrary to our rules - please read all the rules.
On the other hand if you haven't actioned this within a day I'll treat is as spam and delete the thread and your account
Edit.
The OP didn't respond so I have deleted his post as spam and cancelled his membership here.
Last edited by Richard Buttrey; 12-12-2018 at 10:01 AM.
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star iconbelow the post.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks