Hi,
Aim:
I am building a database that picks up the results of a table in excel. (The table in excel is created by combo boxes and list boxes). I have about 100 of these excel tables in different files.
Problem 1: I want to go into each file, and pick up data, and populate a master table in...