xls
-
i need open file xls from query? i used this command select * FROM OPENDATASOURCE('Microsoft.Jet.OLEDB.4.0', 'Data Source=C:\a.xls; Extended properties = Excel 8.0')...[sheet1$] a but make error Server: Msg 7314, Level 16, State 1, Line 15 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. OLE DB error trace [Non-interface error: OLE DB provider does not contain the table: ProviderName='Microsoft.Jet.OLEDB.4.0', TableName='sheet1$']. -------------- i'm sure from sheet1$ is exist in file a.xls
123
-
i need open file xls from query? i used this command select * FROM OPENDATASOURCE('Microsoft.Jet.OLEDB.4.0', 'Data Source=C:\a.xls; Extended properties = Excel 8.0')...[sheet1$] a but make error Server: Msg 7314, Level 16, State 1, Line 15 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. OLE DB error trace [Non-interface error: OLE DB provider does not contain the table: ProviderName='Microsoft.Jet.OLEDB.4.0', TableName='sheet1$']. -------------- i'm sure from sheet1$ is exist in file a.xls
123
-
hi 123, excle file should have sheet with name "sheet1" i.e. excluding $ sign.
Regards KP