Replace a table on import

[lovemuscle2005]

Hi all,

I want to Import a table from another daabase using TransferDataBase.

I want it to overide the existing table instead of appending or naming the new on NAME1. I know this is easy, but having a mental breakdown!

Cheers In Advance

 

[Norie]

Delete the existing table before doing the import.

Or import, delete original table and then rename new table.

 

[Ziggy]

If the data from your table is in the same structure as the one you want to delete then, you should create an import that first runs a delete query to the table to clear out the records followed by the import. The only reason that you might not like this is if you are concerned about an autonumber ID field that will increment with each import.