A more efficient way to reload data

Database
Enthusiast

A more efficient way to reload data

Hi everyone,

Im facing a small problem, having a procedure that drops the whole table and refreshes (i'm not totally sure that this is the correct way to describe it) will

cause some problems in my opionion if that table consists of possibly 10,000,000 rows and even more. 

Is there a more efficient way to refresh with data, more like adding data, adding rows?

Best regards

Emil