Appending data

[SteveE]

I import daily 2-3,000 records from a text file received by email from our main server and then import the records into my database, each record consists of 20 fields abd the updated data is contained in 3 fields which are updated on the main server as the day goes on.
I need to update the access records with only the updated fields at the time of import, I know I can make a unique field in the record as no duplicates [order no] but that would just not accept the whole record, can anyone please advise my best way forward.

Steve

 

[namliam]

Can it be that simple?

Run an update query?? instead of an append... (import)

Regards

 

[MattS]

To run an update query would require some sort of uniqueness on the records, and I think that is SteveE's problem:

I know I can make a unique field in the record as no duplicates [order no] but that would just not accept the whole record

I'm not certain, but unless some sort of ID can be added at source, I can't see any other way to do it.

Matt.

 

[namliam]

I can make a unique field in the record as no duplicates [order no]

The record has a unique field....

 

[SteveE]

Thank for that but the problem is the unique aspect of each record as sometimes the order number will appear more than once ie failed delivery and 2nd attempt etc. (the updated fields show the date, time and comment of each event)

Steve

 

[MattS]

In that case it probably is as simple as running an update query.

Maybe I was trying to over-complicate things - I think I need to lay down in a dark room for a little while.

 

[MattS]

So the order_no and delivery_attempt no make each record unique (i.e. order 1, attempt 1 / order 1, attempt 2 etc..)?