沒有吃晚飯在此加班解決問題﹐請DX幫忙看看﹐非常感謝﹗
進行以下語句查詢﹕
SELECT * from OpenDataSource('Microsoft.Jet.OLEDB.4.0','Data Source="C:\C.xls";Extended Properties="Excel 5.0;
HDR=Yes;";Persist Security Info=False')...sheet1$
報以下錯誤﹕
伺服器: 訊息 7314,層級 16,狀態 1,行 1
OLE DB provider 'Microsoft.Jet.OLEDB.4.0' does not contain table 'sheet1$'. The table either does not exist or the current user does not have permissions on that table.