Hello everybody. I've developed an idea for a database that would save people at my company a lot of time and frustration. The only problem is I'm spending a lot of time and getting frustrated while trying to build the dang thing. It seems like it should be a rather simple and straight forward database so hopefully someone can lead me in the right direction.
I have somewhere in the ballpark of 25-30 large excel files, all containing over 30K part numbers along with various details and descriptions pertaining to each one. All of these files have the same column headings. Some of these files will contain the same part number, but with a different description depending on which file it is coming from. What I wish to do is create a form with a single text box in which a user inputs a part number(s) and then have the desired field of information drawn from all of the excel files in which the part exists.
I know this is going to involve importing all of the excel files into Access as tables, which is as far as I have gotten. From here I'm not sure where to go or what needs to be done. If anyone could assist by suggesting ways in which this can be done, or directing me to resources where I can learn this, that would be fantastic! I've been looking all over the internet to find such a thing but haven't come across anything yet.
Thank you