Is it possible to import a single fields data for restore

[Miss A!]

Hi there,

 

I have a field that has been altered for more than 100 000 records to the same value, it is a number field - I would like to know if it is possible to restore the old values for this field from a latest backup, importing only for this field.

 

please help and many thanks,

 

Miss Amen

[Wim Decorte]

Sure.  In the import mapping, select the "matching" option for the primary key field, and only add the rogue field to the rest of the import order.  Make sure you start with a full found set in the table you want to import into.