I've created various tables in access,to store some data that will be added later with forms or imported from excel files.
the excel file I'm working with have several sheets, and repeated columns between themselves, so i created more one or two tables in order to store the data in only one place.


the problem is that i can't find the way to import "automatically" data from that sheets specifically in to the columns i want.
I'm gonna give an example to be easier: the sheets in excel have for example an entity column and other columns with entity data such as addresses, phone, that are common for several sheets of that file so i created an entity table in access DB in order to reduce the redundancy of the data in the DB and thus its size, but i don't know how to import just that columns to the entity table in access DB... Can someone help me?