When you try connecting Access database in visual studio.
importing excel file into SQL Server
OS: Windows 2008 R2
Error: The ‘Microsoft.ACE.OLEDB.12.0’ provider is not registered on the local machine. (System.Data)
Solution; (If you have Office installed in the system you may not come across this)
Install the following from the link given below. (Access Database Engine)