Microsoft Access - I have three excel tables that I imported into Access, and I need to link them

Asked By David DiSchiavi on 15-Jun-17 09:07 AM

I've imported the three excel tables, and I've made it so that the primary key column names match each other. I need to find a way to link them into one table or form/report so I can easily update them for the future, since updating each individual sheet in excel was getting tedious. Also, I have multiple repeats of column names, for example:


Company XXX

Company XXX

Company XXX

Company XXX

Company ABC

Company ABC


Co W

Co W

Co W


I want to find a way to condense this so that only one company name pops up for each company, and then by clicking on that one name I can access all of the information behind that company as well. Any help is appreciated