Mutiple Excel Files Import to Access
This is a question as to how difficult something would be for a person like myself who does not know code well but has tweaked code to use in my Databases with the help of you folks here.
The task is:
Taking multiple Excel Spreadsheets (and the number of files will be different every day) with multiple tabs of data within each file and only taking the first row of data on each tab and importing all this data into one table in an Access Database automatically…I know how to import data from Excel using a Macro but this is different—I have only done one table imports and the fields are always the same, they never change.
Many of these Excel files will not have the data in the same columns, it will be different with almost every spreadsheet and multiple tabs with each file, I have no clue on how to do this or if I even can without knowing code.
I found an article on importing multiple Excel files into a Database to create one table, but the fields are all the same within the multiple Excel files and only 1 tab.
I just don't know how to answer this question…as I don't know if it is possible without the knowledge of code…I appreciate your guidance.