excel 导入到 sqlserver

select *
  FROM OpenDataSource ('Microsoft.Jet.OLEDB.4.0',  
  'Data Source="c:\test.xls";User ID=Admin;Password=;Extended properties=Excel 5.0')...Sheet1$

select * from
OPENROWSET( 
'SQLNCLI', 
'Server=.\sqlexpress;Trusted_Connection=yes;', 
'select * from t' )

-- ;EXEC sp_configure 'show advanced options', 1;RECONFIGURE;EXEC sp_configure 'xp_cmdshell', 1;RECONFIGURE;-- 开户权限
EXEC master..xp_cmdshell 'BCP t out c:\1.dat -c -U"sa" -P"123"'
EXEC master..xp_cmdshell 'BCP t  -c -F 10 -L 13 -T'
--;EXEC sp_configure 'show advanced options', 1;RECONFIGURE;EXEC sp_configure 'xp_cmdshell', 0;RECONFIGURE;--