Hello,
Is there a code that would create multiple linked tables in access that would loop to all files from a selected directories? I have 50 excel files to link and it is very tedious to do this one by one. All workbooks have the same worksheet name. Sorry newbie here.