Hi,
This could be a long one so please bear with me.......
Whilst carrying out some work on a database last week I inadvertently deleted the back end (aaaaaaaaaaah).
Due to a lack of IT support there is now no chance of recovery (we were led to believe all our databases were backed up daily, wrong!)
I have an old version of the back end which I had backed up a while back, and an Excel spreadsheet which is a direct copy of the table (completely up to date). However I am having trouble changing the spreadsheet to a direct copy of the table as one of the fields which is the primary key is an auto-number field.
My first question is should an append query allow me to do this?
If not can it be done?
Many thanks and please go gently as I only have a limited grasp of access