Originally Posted by
ranman256
the tables I use are:
tClassroom. (has list of all in the class by StudentID, )
tClassAssignments (all work assigned to students in the class)
tClassWork (each students result of the assignments)
for updates,
download the excel file by saving it the same place everytime, i.e.: c:\temp\File2Import.xls
overwriting it each time.
PREP:
link this as an external table. (done only once)
build an append query to import the data from the xl file.
put this query in a macro.
STEPS: then the steps are:
1. save the XL file,
2. run the macro.
done.
and all imports go into 1 table. The date will differentiate the records.