Hi.
How can I import and append columns from 1000 mdb files into one table in excel? I've tried to open mdb directly, or to import access database, it works ok, but I didn't figured out how to do it with multiple files.
Thank you.
Hi.
How can I import and append columns from 1000 mdb files into one table in excel? I've tried to open mdb directly, or to import access database, it works ok, but I didn't figured out how to do it with multiple files.
Thank you.
import 1000 mdb into 1 access table, via linked table & append query.
then export it to XL.
this code scans the enire folder then links each table ,
then it runs an append query: qaImportAccTbl ,to bring the data in
until all files are imported.
Please Login or Register to view this content.
Last edited by ranman256; 03-05-2020 at 10:35 PM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks