Hi All,

I've tried to do some research about this online, but I haven't been able to find a situation similar to mine. I think this will either be very easy and I'm overlooking something, or next to impossible.

I work in a program at a college and we have both the college database (Oracle) and a program database (Access). I do a fair amount of work in both of them, though the program database in Access is the only one I have the power to modify. What I am trying to do is get student Placement test scores out of the School (Oracle) database and into the Program (Access) one. I am able to Export the scores from the school database into an Excel spreadsheet. Normally, it would just be a matter of importing that spreadsheet into the respective Access table, which I've done countless times, but in this case that's not an option.

The reason I can't just do a direct import is because the student records already exist in the table. The Placement test column is blank, and I just want to fill in that column for all the students who took it. When I tried a direct import, Access appended the already existing records to the table, so I ended up with duplicates. The next thing I tried was to make a command button and back it with VBA if/then statements. The way I kept track of which student belonged to which score was by studentID. For example: If StudentID="abc" Then TestScore="123" ElseIf StudentID="cde" Then TestScore="456" and so forth. The problem here was that the button would only execute one statement every time I clicked it, so I'd have to click it 50 times if I wanted to add test scores for 50 students. I don't think that's a good solution. I'm not sure if the conditional if/then statements would even be appropriate for what I want to do. I tried looping so that all 50 of my if/then statements would execute with one button click, thought about arrays, but I have no idea where to even begin. Could someone please point me in the right direction? My experience is that I've taken an Introduction to Visual Basic, so I know the basics, but if you have ideas for anything advanced if you could please explain at beginner level, I'd really appreciate it. Thank you!