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

posted @ 2008-03-10 19:13  D10.天地弦  阅读(374)  评论(0)  编辑  收藏  举报