EXCEL导入SQL

EXCEL导入SQL 

上一篇: TreeView相关 |  下一篇: 在线播放各种文件

<script type="text/javascript">function StorePage(){d=document;t=d.selection?(d.selection.type!='None'?d.selection.createRange().text:''):(d.getSelection?d.getSelection():'');void(keyit=window.open('http://www.365key.com/storeit.aspx?t='+escape(d.title)+'&u='+escape(d.location.href)+'&c='+escape(t),'keyit','scrollbars=no,width=475,height=575,left=75,top=20,status=no,resizable=yes'));keyit.focus();}</script>

<script src="http://wz.youkuaiyun.com/javascripts/vote.js" type="text/javascript"></script> style="MARGIN-TOP: 0px; FLOAT: left" border="0" marginwidth="0" framespacing="0" marginheight="0" src="http://wz.youkuaiyun.com/vote.aspx?t=EXCEL%u5BFC%u5165SQL%20-%20inshine%u7684%u4E13%u680F%20-%20优快云Blog&u=http%3A//blog.youkuaiyun.com/inshine/archive/2005/10/27/517825.aspx" frameborder="0" noresize="noresize" width="54" scrolling="no" height="75">  EXCEL导入SQL   <script src="http://blog.youkuaiyun.com/count.aspx?ID=517825&Type=Rank" type="text/javascript"></script>   

insert into 表1(列1,列2...) select * from | select 列1,列2 into 表 from
openrowset('Microsoft.Jet.OLEDB.4.0', 'Excel 8.0;database=c:/aaaa.xls;HDR=Yes;IMEX=1', sheet1$)

 

imex=1是表示把混合数据类型强制转换为文本行

 

--导入已经存在的表中
insert into 表
select * from
OPENROWSET('MICROSOFT.JET.OLEDB.4.0'
,'Excel 5.0;HDR=YES;DATABASE=c:/test.xls',sheet1$)

--导入并生成表
select * into 表 from
OPENROWSET('MICROSOFT.JET.OLEDB.4.0'
,'Excel 5.0;HDR=YES;DATABASE=c:/test.xls',sheet1$)

Trackback: http://tb.blog.youkuaiyun.com/TrackBack.aspx?PostId=517825