Hello !!
I am new working with Microsoft Access and am having some trouble figuring out how to automatically upload multiple sheets in different workbooks into Access. I tried using the Import Macro function, but only works for complete workbooks and not specific spreadsheets. To explain what I want to do, I have 3 different files with different names but the tables and data in them is the same. I just need to import 2 of the tables from each of the workbooks. One of the tables is in a sheet called Database and another in a sheet called Session, all of the tables have the same variables.
Please if someone can shed some light it would be awesome. Thank youuu !!
Ale
I am new working with Microsoft Access and am having some trouble figuring out how to automatically upload multiple sheets in different workbooks into Access. I tried using the Import Macro function, but only works for complete workbooks and not specific spreadsheets. To explain what I want to do, I have 3 different files with different names but the tables and data in them is the same. I just need to import 2 of the tables from each of the workbooks. One of the tables is in a sheet called Database and another in a sheet called Session, all of the tables have the same variables.
Please if someone can shed some light it would be awesome. Thank youuu !!
Ale
