Update query

[Daryl2106]

Hi,



I recieve excel data (which I import to an Access table) containg updates with student course enrolements. The updated excel table contains both new added and current records. I am trying to append the new enrolements to my current table by comparing the data in a single field so only new records are appended. I am having no luck. Any suggestions are greatly appreciated.

Thanks and take care,

Daryl

[ssanfu]

Hi,

I recieve excel data (which I import to an Access table) containg updates with student course enrolements. The updated excel table contains both new added and current records. I am trying to append the new enrolements to my current table by comparing the data in a single field so only new records are appended. I am having no luck. Any suggestions are greatly appreciated.

Thanks and take care,

Daryl

OK, what do you mean by "no luck".
What is or is not happening?
How are you doing the imports?
What code (if any) are you using??

[Daryl2106]

I am getting the Enter parameter value dialogue. The only criteria I defined was: <>[StudentEnrollmentTable]![ProgressKey]. I admit I know very little access at this point.

Take care,

Daryl

[ssanfu]

I am getting the Enter parameter value dialogue. The only criteria I defined was: <>[StudentEnrollmentTable]![ProgressKey]. I admit I know very little access at this point.

Take care,

Daryl

My crystal ball is in the shop; I tried to read your mind, but all I'm getting is a blank. You're killing me here...........

So....
How are you doing the imports?
What code (if any) are you using??
If you are using a query, what is the SQL???

Please explain a little more..........