When I am importing .dbf files into access to create a new table I want to be able to replace old tables with the same name. I can do this when importing an excel file to create a table, but when Importing a .dbf if a table exists with the same name access renames the new table. For example if I import a file named market and a table named market already exists, access creates a new table called market1. I need to be able to import the .dbf file and automatically replace the old one, so there is only one table in the database. Is this possible to do with dbf files.