Using VBA in Word97 to code a macro, I am using the DoCmd.TransferText to import a text file into an Access database.

My problem is - when I run the macro again after the first time, the data appends to my existing table, but I want it to overwrite the existing table.

Are there any arguments to the TransferText command that overwrites a table if the same table name is specified?