If you shorten the key of a table (for example, when you remove a key field or shorten the field length of key fields), this may result in duplicate records with the same key. When you reload the data from the temporary table, only one of these duplicate records can be loaded back to the table. It is not possible to predict which record is loaded back to the table. If you want to copy certain records, you have to clean up the table before the conversion.