摘要:
导入如果表已存在,SQL语句为:insert into aa select * from OPENDATASOURCE('Microsoft.Jet.OLEDB.4.0','Data Source=D:"OutData.xls;Extended Properties=Excel 8.0')...[sheet1$]其中,aa是表名,D:"OutData.xls是excel的全路径sheet1后必须加上$如果表不存在,SQL语句为:SELECT * INTO aa FROM OPENDATASOURCE('Microsoft.Jet.OL 阅读全文
posted @ 2011-07-19 15:52 analyzer 阅读(1227) 评论(0) 推荐(0) 编辑