DB:MsSQLServer2005 dbFile:2003 Excel ** 注意事項：
2. 重新啟動mssqlserver 服務
3. 確保dbfile檔案處於非活動狀態(不要開啟或有程式在讀)
4.確保dbfile的列數與表結構一致 exec sp_configure "show advanced options",1 reconfigure exec sp_configure "Ad Hoc Distributed Queries",1 reconfigure EXEC sp_configure "show advanced options", 1 GO RECONFIGURE GO EXEC sp_configure "Ad Hoc Distributed Queries", 1 GO RECONFIGURE GO SELECT * from OPENROWSET("MICROSOFT.JET.OLEDB.4.0" , "Excel5.0;HDR=YES;DATABASE=e:\\testdata.xls",sheet$) ;
DB:MsSQLServer2005 dbFile:2003 Excel ** 注意事項：
2. 重新啟動mssqlserver 服務
3. 確保dbfile檔案處於非活動狀態(不要開啟或有程式在讀)
4.確保dbfile的列數與表結構一致 exec sp_configure "show advanced options",1 reconfigure exec sp_configure "Ad Hoc Distributed Queries",1 reconfigure EXEC sp_configure "show advanced options", 1 GO RECONFIGURE GO EXEC sp_configure "Ad Hoc Distributed Queries", 1 GO RECONFIGURE GO SELECT * from OPENROWSET("MICROSOFT.JET.OLEDB.4.0" , "Excel5.0;HDR=YES;DATABASE=e:\\testdata.xls",sheet$) ;