Error while connection to MS Access by selecting A MICROSOFT ACCESS DATABASE
I would like to transfer some of my files of * .mdb and* .Accdb format (Microsoft Office Access 2010) and also files of.XLs, .Xlsx and.Xlsb format (Microsoft Office Excel) to another data source, i.e. Microsoft SQL Server.
In doing the above task I need to connect to MS Access by selecting a Microsoft Access database. Whenever I try to do that an error message pops out.
Does someone know how to fix this up?
No appropriate Access provider was found.
I do not understand the reason behind this. I also tried reinstalling Microsoft Office 2010 but the error still persists.
Help me out from this problem I am really struck with lots of work left behind.