Copy from Excel to Access, delete data from DB before paste.

Hi,

Got some standard code which copies data that is within Excel accross to access however I want the code to delete what ever is in the Access table before it pastes it over as at the moment it is just appending the data to it.

Thanks,

Please Login or Register  to view this content.

Any ideas?

Thanks