EXCEL导入到SQL Server

insert into L02_DATA_T(p_Layer_ID,P_ID,P_Name,Mapx,Mapy)  
select '175'as Layer_ID,P_ID,P_Name,MApx,Mapy from 
OPENROWSET('MICROSOFT.JET.OLEDB.4.0'
,'Excel 5.0;HDR=YES;DATABASE=C:\Documents and Settings\Administrator\桌面\text.xls',sheet1$)

posted @ 2009-10-27 15:52  好俊的功夫啊  阅读(209)  评论(1编辑  收藏  举报