Hi there,
I was having the same problem as horhif, so I went through as advised and input the data into a new table, creating lookup columns for the data so it matched the first table. I then subsequently attempted an append query in order to add the new records to the first table.
However...