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$)