I am creating a simple database that tracks the GPA records of each
students.
Every semester i recieve a excel file with information about the students
ID
and GPA for that semester. I want to im****t the excel file with their
information and update the existing information for each students in the
access db. Specifically i want to fill in the GPA information into
existing
column in the table that I have created for each semester ( i have created
a
field for future semesters separately). Access does not let me do that as
it
violates the primary key which is the student ID.
Is there another way to im****t and update my table. approach that i have
tried is to im****t the data into a temp table each semester and try to
update
the master table using this temp table. But i dont know how to do that too
using sql code as the fields are variable each semester.
Master_Table
ID Fall 08 GPA Spring 08 GPA
1 Yes 3.5 (to be updated) (to be updated)
Temp_table
ID Semester GPA
1 Spring 08 3.6
So the information i get is temp table. Depending on the semester value, I
need to locate the field in master table which in this example is spring
08
and update the GPA corresponding to that semester.
If i can directly update the master table using im****t, it would be good.
Or
else is there another way?
Please help me
Thanks
