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.
"Klatuu" wrote:
[Quoted Text] > 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.
>
> "Eleanor of Aquitaine" wrote:
>
> > 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?
|