ADO打开操作Excel
Provider=Microsoft.Jet.OLEDB.4.0;User ID=Admin;Data Source=E:\My Documents\资金流水帐.xls;Extended Properties=Excel 5.0;Persist Security Info=False
查询分析器里面Open Excel数据
SELECT *
FROM OpenDataSource
('Microsoft.Jet.OLEDB.4.0',
'Data Source="E:\mfProgram\sferpProject\Release\Server\期初导入.xls";User ID=Admin;Password=;Extended properties=Excel 5.0'
)...[Sheet1$]