Re import data

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

- 11 Jun 2004 15:56 GMT

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?

Reply to this Message

John Nurick - 12 Jun 2004 21:12 GMT

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

On Fri, 11 Jun 2004 07:56:14 -0700,

>I have a database which i import text files into.
>Periodically the text file is updated and i need to re
[quoted text clipped - 3 lines]
>the data that is already in the table rather than
>duplicate it can this be done?

--
John Nurick [Microsoft Access MVP]

Please respond in the newgroup and not by email.

Reply to this Message