SELECT * FROM OpenDataSource('Microsoft.ACE.OLEDB.12.0','Data Source="d:\excel.xls";Extended properties="Excel 12.0;"')...Sheet1$
注意:别删除后面的三点,还有表名后面要跟$
SELECT * FROM OpenDataSource('Microsoft.ACE.OLEDB.12.0','Data Source="d:\excel.xls";Extended properties="Excel 12.0;"')...Sheet1$
注意:别删除后面的三点,还有表名后面要跟$