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 the database. How do I do this? (all fields in excel are labelled - eg comboboxdate etc)
Problem 2: Each excel file has a different name, and I have a table in access with all these names. I want to loop through each name in the access table, and pick up data from each excel file. How can I do this?
Any hints to get me started?
Thanks
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 the database. How do I do this? (all fields in excel are labelled - eg comboboxdate etc)
Problem 2: Each excel file has a different name, and I have a table in access with all these names. I want to loop through each name in the access table, and pick up data from each excel file. How can I do this?
Any hints to get me started?
Thanks