Convert Access to SQL Database

Currently have working access database that runs some complex VBA scripts and exports the results to excel sheet
Convert Access to SQL Database.
Rewrite VBA scripts that run in access to run in SQL Database and export results to excel sheet
Import daily updates from Excel sheet into SQL Database
Export daily stats into excel for charts
Report on any errors via email
Remove any tables etc. that are not required to reduce size of database (current access size is 1.3GB)
SQL2008 R2 Provided and remote access
Follow on work: Support and scripts as required