[SQL SERVER] 用SQL語句讀取Execl資料

USE [master]EXEC sp_MSset_oledb_prop N'Microsoft.ACE.OLEDB.12.0' , N'AllowInProcess' , 1EXEC sp_MSset_oledb_prop N'Microsoft.ACE.OLEDB.12.0' , N'DynamicParameters' , 1EXEC sp_configure 'show advanced options', 1RECONFIGURE EXEC sp_configure 'Ad Hoc Distributed Queries', 1 RECONFIGURE  SELECT * FROM OPENROWSET('Microsoft.ACE.OLEDB.12.0','Excel 8.0;IMEX=1;HDR=YES;Database=檔案路徑', 'SELECT * FROM [Sheet1$]')EXEC sp_configure 'Ad Hoc Distributed Queries', 0 RECONFIGURE  EXEC sp_configure 'show advanced options', 0RECONFIGURE EXEC sp_MSset_oledb_prop N'Microsoft.ACE.OLEDB.12.0' , N'AllowInProcess' , 0EXEC sp_MSset_oledb_prop N'Microsoft.ACE.OLEDB.12.0' , N'DynamicParameters' , 0