Inporting data to specific record

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a database of students with unique ID numbers. When they complete an
assignment, their results are caluclated in an Excel Spreadsheet. I want to
import the scores to matching fields in my database. so I want to do an
export or import (whichever is easiest), match to the unique ID and then fill
in the fields.

It's not an update query, because I'm not replacing data and it's not an
append query because I'm not adding new records. I just want to match the
record and then fill in the fields.

Any suggestions?
 
My first suggestion would be to abandon the Excel spreadsheet and enter the
data directly into Access.
If there is some overriding reason that can't be done, you will have to do a
little work.
I would link to the Excel sheet, then create a query based on the Access
table and the Excel sheet, joined on whatever your primary key fiend is, and
use that is the record source for the form where the data will be entered.
 
Okay, thanks for the input. I thought I might be missing something, but I
will take your suggestion and forget the Excel.

Thanks for the prompt response.
 
Back
Top