search "opendatasource" in you SQL books on line helpSELECT *
FROM OpenDataSource( 'Microsoft.Jet.OLEDB.4.0',
'Data Source="c:\Finance\account.xls";User ID=Admin;Password=;Extended properties=Excel 5.0')...xactions
FROM OpenDataSource( 'Microsoft.Jet.OLEDB.4.0',
'Data Source="c:\Finance\account.xls";User ID=Admin;Password=;Extended properties=Excel 5.0')...xactions
FROM OpenDataSource( 'Microsoft.Jet.OLEDB.4.0',
'Data Source="c:\test1.xls";User ID=Admin;Password=;Extended properties=Excel 5.0')...cl_clbm
cl_clbm是我的excel工作表,是直接从数据库导出的,但是提示错误:
OLE DB provider 'Microsoft.Jet.OLEDB.4.0' does not contain table 'cl_clbm'. The table either does not exist or the current user does not have permissions on that table.
是什么原因呢?