I am using Microsoft sql server 2012 with visual studio 2010 to load multiple excel files. Visual studio script image
After loading multiple excel files, when executing the task, below error occured.
"Microsoft.Jet.OLEDB.12.0 is not registered. If the 64-bit driver is not installed, run the package in 32-bit mode. Error code: 0x00000000" .
I have taken below steps, 1. Installed access database engine, https://www.microsoft.com/en-us/download/details.aspx?id=23734 (2007) & 2010 which is 32-bit.
After changing step#2 again "If the 32-bit driver is not installed, run the package in 64-bit mode" error occurs.
I'm trying to overcome this error but I couldn't. If I install higher versions can I overcome this error do I need to change any settings in present settings?
Please help me out.
User contributions licensed under CC BY-SA 3.0