Exel to access import with specific cells (1 Viewer)

RandRob said:

I have a excell spreadsheet
which will contain Scanned test scores

in this spread sheet i will have a column for a student id a column for a coarse name and a column for the score

ID Course_Name Course Grade
101 Course 1 98
101 Course 2 89
102 Course 1 85

i also will have a access table set up as follows

id Course 1 course 1 Grade Course 2 Course 2 Grade

in this table some data may already be enteredso it can look like this

id Course course 1 Grade Course Course 2 Grade
102 Course 2 89

what i now need to do is have it search based student id and course name
Then import the data into the proper cell in the row
now this actually had spaces for 60 tests

some already filled in and some blank
so each time i run this macro
i hope it can search a student id then find the matching score and fill in the proper cell in my table to update it for me

so in the above example after running the macro the access table would look like this now

id Course course 1 Grade Course Course 2 Grade
102 Course 1 85 Course 2 89
101 Course 1 98 Course 2 89


Is this possible to do?

Click to expand...

id Course course 1 Grade Course Course 2 Grade
102 Course 2 89

Click to expand...

RandRob said:

how should it be designed?

here is a brief look at what i have

currently we will use this to track more then 9000 students taking bible coarses in prisons

we currently have 60 separate courses

i have three tables one for basic enrolment info
one for updated info (home address etc if needed)
one that lists the coarse info
with a column for coarse grade date sent and recieved for each
course

any thing you can suggest i am willing to try
i originally planned to make this with a table for each course and was told not to
was suggested to do it this way
and it actually works well for doing manuall entering of data

The issue has came up only because we now need to import data from scanned tests which after scanning gives us a excel spreadsheet

so any suggrestions are welcome

Click to expand...

CourseID     StudentID       CourseGrade
    1            101             98
    2            101             89
    1            102             85