excel txt 导入 sql

 select a, b into fromualid_temp
 from
 OPENROWSET('MICROSOFT.JET.OLEDB.4.0'
 ,'Excel 5.0;HDR=YES;DATABASE=d:/formualid_trans.xls',sheet1$)

 

 

1. bulk insert xsxt.dbo.tabletest from 'c:/data.txt'  
2.  with(   
3.    FIELDTERMINATOR=',',   
4.    ROWTERMINATOR='/n'  
5. )