Hello everyone,
I have been searching the web for a solution to this without and success and I am hoping someone on this site can help.
I am working on importing information from an Excel workbook into 15 different tables in an existing Access database. What I have is a parts library in Access that feeds into our design tool and I am trying to incorporate inventory information from our ERP (inventory Management) system into the design tool through our Access database to be able to report the current inventory along with the part data.
I have been able to link the excel workbook exported from our ERP as a linked Table in Access but I cannot figure out how to lookup the corresponding inventory information in the linked Table and have it reported in each of the 15 tables. I am basically trying to do the equivalent of an Excel Vlook in access so only 1 file needs to be updated on a regular basis.
I understand I can create a query to do this easily but I need the information linked to a table to correctly import to our design tool. I also looked into have a query generate new tables each time but all sorts of formatting issues and seemed like a clumsy way to transfer information from one table to another.
Hopefully this has come up before, maybe someone can point me in the right direction. Unfortunately I couldn’t find any threads addressing this. Any assistance is greatly appreciated.
Best Regards,
Brad
I have been searching the web for a solution to this without and success and I am hoping someone on this site can help.
I am working on importing information from an Excel workbook into 15 different tables in an existing Access database. What I have is a parts library in Access that feeds into our design tool and I am trying to incorporate inventory information from our ERP (inventory Management) system into the design tool through our Access database to be able to report the current inventory along with the part data.
I have been able to link the excel workbook exported from our ERP as a linked Table in Access but I cannot figure out how to lookup the corresponding inventory information in the linked Table and have it reported in each of the 15 tables. I am basically trying to do the equivalent of an Excel Vlook in access so only 1 file needs to be updated on a regular basis.
I understand I can create a query to do this easily but I need the information linked to a table to correctly import to our design tool. I also looked into have a query generate new tables each time but all sorts of formatting issues and seemed like a clumsy way to transfer information from one table to another.
Hopefully this has come up before, maybe someone can point me in the right direction. Unfortunately I couldn’t find any threads addressing this. Any assistance is greatly appreciated.
Best Regards,
Brad