Microsoft.Jet.OLEDB.12.0 is not registered in Visual studio 2010

0

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.

  1. Changed the Run64bitruntime to False to run in 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.

visual-studio-2010
sql-server-2012
asked on Stack Overflow Oct 3, 2018 by krishna31

0 Answers

Nobody has answered this question yet.


User contributions licensed under CC BY-SA 3.0