By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
425,863 Members | 853 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 425,863 IT Pros & Developers. It's quick & easy.

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

P: 1
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
Apr 24 '12 #1
Share this Question
Share on Google+
1 Reply


NeoPa
Expert Mod 15k+
P: 31,418
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 ;-)
Apr 25 '12 #2

Post your reply

Sign in to post your reply or Sign up for a free account.