 So I've gone ahead and jumped ahead a little bit if you want you can follow along in your book But I've added in a few more records now one thing I do want to specify at least when we're dealing with these things is We have to make sure that our visit IDs are all unique say for example this last one 1560 say for example, I had made it a little typo. I had said 1564 1564 I've already got a 1564 in here and inside of Excel didn't matter Since I try and hit enter and I move through this You see what happens I get a little error now We have to read error messages because they tell us what's wrong again the changes you requested to the table were not Successful because they would create duplicate values in the index primary key or relationship. I don't know what any of those words mean We will in a second change the data in the fields that contain duplicate data remove the index or redefine the index to permit duplicate entries And try again, so it's not gonna. Let me I can't save this I Can't I Can't move out of here. I can't do anything Like I'm stuck You see I'm stuck now and it's all because this guy is a duplicate value again every Visit ID is unique. That would be like your social security number being the same as somebody else's social security number You don't want your you know credit to go down because someone else is taking out ludicrous amounts alone because well They know your social or they have the same social as you The same concept is coming in here because I have one here again I can't even change it. I've already committed to that one because I've made the change here. I Have to do it now in our case so I can either hit escape or Backspace zero 1560 again and now because it's a unique value. There are no 1560s here I can click out of it. There we are Now again, I clearly don't want to type all of these things So what I want to go ahead and do is I want to go ahead and import them from another database that Cindy Database that if you've downloaded the textbook files, you have access to and if I open it up It looks like this. This is what I'm gonna see again Notice how I don't get a lot of stuff and oh There's warning scaredy-warning. You're sending me hacking viruses and all that mister. Go in now I'm not this is access being a little cautious because we're dealing with really a Lot of data a lot of sensitive data It's being a little bit of kind of that that big brother. Hey, you know, you're dealing with some complex stuff here I just want to make sure you know what you're doing before you actually do it It's gonna do that a lot you're gonna notice So we do actually have to say enable content then again We have to open up that appointment Table by double-clicking on it and you can see it's already got a bunch of them for us Now I want to go ahead and take all of these and I want to bring them into my database The quickest way I can do this is actually by clicking on that little square right beside visit ID And bringing it all the way down. Now what this allows me to do is copy and Then if I come over to my database and I click on that little star notice what happens to the paste option. Oh Paste just became active. So that means if I clearly click on it Again, I told you that access is gonna be very big brothery. It's gonna make sure that everything you do It's very explicit and it wants to make sure you mean it So as you can see are you sure you want to paste these records because once you do, you know They're committed and if you have other back-end stuff working on that Well, you know 76 records just kicked it. So again because we're doing it. I do want to do that I want to go ahead and say yes And for my sake I can go ahead and close out of Cindy Again access wants to vary Abruptly make sure that you are doing everything that you want to do So you just copied a large amount of data. We did 76 records. That's a large amount of data in access terms Do we want to keep that in the clipboard or not? Well, do you want to save this data to the clipboard in this case? We actually we don't care about it We've already pasted it. So we're gonna go ahead and say no