从Excel导入数据

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$]

转载于:https://www.cnblogs.com/DKSoft/archive/2008/03/10/1099307.html