I have a SQL database with a table that I need to periodically replace with
data from an Excel spreadsheet.

I wrote a proceedure using ADO to delete each record one by one - then
adding each record one by one, but it takes forever.

Is there a better way to do this?