Welcome to my first post!
I have a bit of a problem and I hope you people can help!
I will, on a weekly basis, be in receipt of about 150 - 200 seperate Excel spreadsheets. All of the spreadsheets will only contain 2 rows of data (header row and 1 row of information).
What I need to do is import these spreadsheets into Access to retrieve the data from but I want to avoid the option of importing each individual spreadsheet one-by-one.
I have figured out the TransferSpreadsheet option in Access but that seems to only import 1 spreadsheet so that is why I am trying to merge all sheets into one.
Can anyone please offer me any advice on this predicement?