I have an Access Contact Database, and various Excells with some of the same and some added information...?

Question

I would like to add that added information into the Access database, each contains First and Last names. The Access is the current one, and the Excels are from previous years that has some Events data that I would like to merge. Any Suggestions on the easiest way. I had 4 older Excels that had Attendee and Noshow categories that I would like to place onto the entries in the Access database...

OK getting redundant, I feel. If anyone can decipher, any assistance would be great. (office suite 2003)

Answer 1

You'll have to add any extra columns you need to the Access db first (Attendee, NoShow, etc.

Then if there are names in Excell that aren't in Access you need to add them..write a query that checks each name in excell and if it isn't in Access..add it.

Then add the needed data you need wherever it matches the name

Answer 2

No, no longer likely (yet i'm getting extra desirable) because of the fact interior the initiating if i enjoyed a individual's solutions i purely clicked on their avatar and extra them as a touch. it appeared to me that's what it became into there for. i wasn't paranoid in any respect, i purely extra and prevalent. now i'm slightly extra careful yet previous conduct die no longer elementary. i nevertheless discover all the privateness stuff slightly stressful because of the fact now you somewhat do no longer know who you're asking. i purely discern that's a recreation of kinds and if i'm getting suspended, i'm going to in basic terms initiate yet another account. i do no longer take the element element very heavily nor do i thumb down or record. i purely appreciate speaking with like-minded human beings. i haven't even examine the regulations, yet i'm getting to grasp. i care extra approximately some monkey wee-wee concentrated on my contacts than reporting me.