There has to be a way to do this... I am trying to make an Access form that will allow me to enter/change certain data in a table and I want to be able to use excel to update some of the data. For example I have a Last name, Grade, and days absent. I also have another database that I can not link to either excel or access that contains the days they were absent. I want to have an access form that I can manualy enter Grade and, if I want, the days absent. It would be easier if I just copy and pase the days absent data from the database to the excel sperad sheet and have excel update the access databse.



The problem I am running into is that I Access won't let me modify data in a linked sheet and I cant index the data in access like I can in excel. They way I copy and paste the data in excel is by using the Vlookup command so that the order in which I paste the days absent does not matter.

Any ideas?
Thank you!