System for WIN10 64
SQL server: Microsoft SQL server 2016 (SP1) (KB3182545) Express Edition (64 - bit) SP1

Has on the Microsoft web site to download and install the access runtime 2013 64 - bit version of the runtime and normal install

In SQL import excel file prompt: "did not register Microsoft on the local computer. ACE. The OLEDB. 15.0 provider"

Excuse me what reason??

CodePudding user response:

A warrior can reply?

Currently only import excel table before 97-2003 format, the format of the file after import will prompt an error message:
Not registered on the local computer "Microsoft. ACE. The OLEDB. 12.0" provider, (System. Data)

This is when the choose excel 2007-2010, 2013 and 2016 turned out to be 15.0 and 16.0, the number in the error message

This and installation is SQL Server Express edition? Also need to install what plug-ins or run the package?

CodePudding user response:

Install this?
http://download.microsoft.com/download/7/0/3/703ffbcb-dc0c-4e19-b0da-1463960fdcdb/AccessDatabaseEngine.exe

CodePudding user response:

Thank you for your reply!!!!!
I am 64 - bit systems, office 365 is 64, so installed AccessRuntime_x64_zh - cn. Exe this 64 - bit version,
In addition to 2016 access runtime cannot be installed, the operation of other libraries are installed, or the same problem,
I wonder if there are other reasons?

CodePudding user response:

Finally found the problem, back to this post keep file,
After many days, N pages in baidu, basic it is said that how to download and install driver, there are also said to the press program version to install both 32-bit and 64 - bit driver,
Thought with a 64 - bit version of SQL, install 64 - bit version accessruntime, inadvertently see the import and export wizard attribute, found a 64 - bit SQL Server 2016 call was 2017 rc1 32-bit wizard, manually start the 64 of the 2016 import and export wizard can normal import the 2013 version of excel file,

In the image below the Program Files directory (x86) are respectively 2016 and 2017 edition 32-bit import and export wizard, the Program Files directory is a 64 - bit of import and export wizard,

CodePudding user response:

Wow!!!!
A lot of posts are reply a settled, also don't say how to solve of,
To post a praise of the building Lord,

CodePudding user response:

How to manually change

CodePudding user response:

Thank you for your advice, it is not I go to success

CodePudding user response:

I met the same problem, look at the various posts, with various versions, finally found here truth and reason, thank you very much!