I have a database in SQL Server 2008 R2.
I have a third-party data provider which is collecting data for insertion into my database.
The third-party company will provide me an Access database with all data once per month.
I need to create some utility or something that anyone behind a keyboard/mouse can use which will:
1) Delete all records from SQL server table
2) Take all records from Access table and insert them to SQL
Field names/data types will be the same between Access and SQL.
What is the easiest/most robust way to automate this process?