Updating Access table from transaction records

[andrefrancis]

I have an Access table (tblSessions) which needs to be updated from a set of transaction records (retrieved from an Excel doc).

tblSessions has fields: SessionRef (AutoNumber, Key), JobRef (Number), SessDate (Date/Time), SessionText (Text), SessionLink (Text, but also unique), Issue (Yes/No).

The transaction record has fields: TSessionLink (for reference), TIssue and TSessionText.

The idea is that each transaction record overwrites the two tblSessions fields Issue and SessionText using identifier TSessionLink to match SessionLink. At the time of update, the Access database will be open.

I will collect the transaction records within an array ... and this I have no problem with.

My problem is the code for the update incuding (presumably) sorting the main table tblSessions into SessionLink order

Can anyone help please?

 

[andrefrancis]

Perhaps it is not clear from my post, that I require some code for the update - I have no idea where to start!