What would be the best way to do this because I am working on a mysql replacement to an old foxpro database and I can import the table once but I am worried that if I try to import it again it will make duplicate records. Another issue is that I have added an extra field to the table which is not in the original table but I would like to keep it preserved some how. Any help would be great. Armando --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php