import data from excel to sql server

https://www.c-sharpcorner.com/article/how-to-import-excel-data-in-sql-server-2014/

需要注意的是，第一次是选择source【excel】

第二次是选择target【sql server】

 

'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine

Well, you need to install it. You're looking for:

• The 2007 Office System Driver: Data Connectivity Components.