Hi

When I said 'lost' I meant the fields were empty. I can see them

I have written a sub that copies the backup tables to xl and then writes the relevant fields to the live db which is working fine.

Thanks for your help, I was out of my depth there and you dragged me up