天天看点

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

继续阅读