How do I import excel data into an existing Access many-to-many relationship table?

[Monique]

I am a new Access user and have taught myself through youtube videos and professional blogs like this one. The database I have created is working wonderfully, and is doing everything that I ask of it except for one thing. I have a many to many relationship table that I would like to populate with data from an excel file. The trouble is that the many-to-many relationship table pulls the primary key number from the related tables to populate the many-to-many table and the excel data that I want to use does that have primary keys associated with it.

The two ways I think this is possible is by either matching the primary keys with the data in excel before importing it into the access database somehow...

Or Importing the excel sheet into a new table in access and then matching primary keys...

Neither of which I know how to do. Any help would be much appreciated :D

[NeoPa]

You may want to reread your question and add some information to clarify what it is you're trying to work with. It seems like an interesting question but it's very unclear what the details are.

Monique:
the excel data that I want to use does that have primary keys associated with it.

Did you mean "...does not have ..."? It's the only way I can make this make any sense. It still doesn't explain what you're working with, but would at least make sense. It's very important to check before submitting a post you understand. You only write it once, but many people can sit there and struggle to make sense of it. That extra bit of care will certainly not lose you any friends ;-)