Re import data

[Guest]

I have a database which i import text files into.
Periodically the text file is updated and i need to re
import it but i get an error that says access was unable
to append the data and that 0 fields were deleted and 300
records lost due to key violations. I want to overwrite
the data that is already in the table rather than
duplicate it can this be done?

 

[John Nurick]

Just use a Delete query to delete the old records before you import the
new ones.