Table / import

[leighms]

Hi
Recently I added a new field to an access table (open date). I than copied the table to excel to get rid of some columns and printed to give to staff to write down the dates for me. (didn't save the spreadsheet)
I have now gone back into the access sheet and the rows no longer run in order as copied to excel (I had previously sorted it by date).
Is there an easy way of loading data to access without having to go through each individual record?

 

[DavidAtWork]

I assume you mean you want to update the field [open date] with the dates as entered by your staff.
"I than copied the table to excel to get rid of some columns and printed to give to staff to write down the dates for me. (didn't save the spreadsheet)"

Oopps, does this mean you only have hand written data, if that is the case, then I don't see any option but to manually update the Access table.
If you have a soft copy of the edited data, is there a PK identifier or unique fields that can be used to link the spreadsheet back to the original table? If so, then you can import the updated spreadsheet and run an update query

David

 

[leighms]

Hi

Thanks for your help, you have steered me in the right direction, i can import the spreadsheet, than use the update query which will be a hell of lost easier than manually entering customer numbers and dates!