Shulou(Shulou.com)05/31 Report--

This article will explain in detail for you how to turn on the sqlserver2014 import EXCEL function, the editor thinks it is very practical, so share it for you to do a reference, I hope you can get something after reading this article.

Install the Microsoft Access 2010 database engine redistributable package on the sqlserver server

This download installs a series of components to facilitate the transfer of data between 2010 Microsoft Office System files and non-Microsoft Office applications.

Download link:

Https://www.microsoft.com/zh-CN/download/details.aspx?id=13255

AccessDatabaseEngine_X64.exe

AccessDatabaseEngine.exe

After the installation is complete, it appears under the linked server option of the server SSMS:

If office2013 is installed on the server, the following 15.0 will appear

1. Open the Ad Hoc Distributed Queries component and execute the following statement in the sql query Editor:

Exec sp_configure 'show advanced options',1reconfigureexec sp_configure' Ad Hoc Distributed Queries',1reconfigure

two。 Close the Ad Hoc Distributed Queries component and execute the following statement in the sql query Editor:

Exec sp_configure'Ad Hoc Distributed Queries',0reconfigureexec sp_configure 'show advanced options',0reconfigure

Select * from OpenDataSource ('Microsoft.ACE.OLEDB.12.0',' DataSource = Erio 12.xlsx extended Properties= "Excel 12.0"). [IMEX1 ").

Import EXCEL with OpenDataSource. If you encounter permission problems, you can copy the EXCEL source file to a new EXCEL file. Then import with the above statement.

Has the ability to delete:

Exec sp_configure 'xp_cmdshell',1

Reconfigure

Exec master.dbo.xp_cmdshell'del E:\ 12.xlsx'

EXCEL can be deleted.

On "how to turn on sqlserver2014 import EXCEL function" this article is shared here, I hope the above content can be of some help to you, so that you can learn more knowledge, if you think the article is good, please share it out for more people to see.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.