Nick, are you doing his with the Kentico Import tool? Do you have an easily identifiable key to know the duplicate rows?
One suggestion, since the custom table is nothing more than a table in your SQL database you could use the SQL DS packager to schedule the imports and can update existing records as well.
We use a different tool that I like a lot better. I will post a link when I get back to my desktop.