Hello,
So to start off, I know enough Excel to be little bit dangerous but I know practically nothing about Access. I am trying to learn Access in hope of creating a database which will "search/import" information from multiple excel documents. To lay the groundwork:
I will have a separate excel document (all located in one folder) for each year which contains information like:
Date, Job #, Personnel, Job Description, Etc... (up to roughly 20 columns)
All this information is located in a table in the second named sheet of the excel document and is formatted the same for each and every year. Each table could be upwards of multiple tens of thousands of lines long.
My hope is to create an access database which would allow me to search the multiple excel documents and import the information (preferably dynamically) to one Access table. The search/import would need the ability to select multiple criteria, such as but not limited to, all dates in between 12/01/2019 and 2/29/2020 and contain the Job # 411111 with the remaining columns being "wildcarded".
I am not sure if I am clear in what I am asking to accomplish and to be honest I am lost on where to begin. Any help, guidance, or similar posts I could read would be greatly appreciated.
Thank you!
KV
So to start off, I know enough Excel to be little bit dangerous but I know practically nothing about Access. I am trying to learn Access in hope of creating a database which will "search/import" information from multiple excel documents. To lay the groundwork:
I will have a separate excel document (all located in one folder) for each year which contains information like:
Date, Job #, Personnel, Job Description, Etc... (up to roughly 20 columns)
All this information is located in a table in the second named sheet of the excel document and is formatted the same for each and every year. Each table could be upwards of multiple tens of thousands of lines long.
My hope is to create an access database which would allow me to search the multiple excel documents and import the information (preferably dynamically) to one Access table. The search/import would need the ability to select multiple criteria, such as but not limited to, all dates in between 12/01/2019 and 2/29/2020 and contain the Job # 411111 with the remaining columns being "wildcarded".
I am not sure if I am clear in what I am asking to accomplish and to be honest I am lost on where to begin. Any help, guidance, or similar posts I could read would be greatly appreciated.
Thank you!
KV