月份: 六月 2021

SQL Server 2012 Express 轉入Excel

SELECT * FROM OpenDataSource( ‘Microsoft.ACE.OLEDB.15.0′,’Data Source="C:\CIT\kkk2021.xlsx";User ID=Admin;Password=;Extended properties=Excel 12.0’)…[sheet1$]

問題：Ad Hoc Distributed Queries

解決：

  1. exec sp_configure ‘show advanced options’,1
  2. reconfigure
  3. GO
  4. exec sp_configure ‘Ad Hoc Distributed Queries’,1
  5. reconfigure
  6. GO

參考網址：https://blog.csdn.net/kk185800961/article/details/9186335

問題：SQL Server Services帳戶

解決：修改為LocalSystem

問題：客戶使用office365

解決：安裝Microsoft Access 2013 Runtime

下載網址：https://www.microsoft.com/en-us/download/details.aspx?id=39358