应用sql查询excel(sqlserver要打补丁)
select
*
from
opendatasource ( ' Microsoft.Jet.OLEDB.4.0 ' ,
' data source="C:Documents and SettingshjxMy Documentsook1.xls";user id=;
password=;extended properties=Excel 5.0 ' )... [ Sheet1$ ]
opendatasource ( ' Microsoft.Jet.OLEDB.4.0 ' ,
' data source="C:Documents and SettingshjxMy Documentsook1.xls";user id=;
password=;extended properties=Excel 5.0 ' )... [ Sheet1$ ]