Who said anything about a "manual process"? Schedule it! BCP, a proc that uses Bulk Insert, and DTS can all be scheduled.
Does your table have a valid, non-surrogate Primary Key? If not, you need to figure out how to make one.
--Jeff Moden
Change is inevitable... Change for the better is not.