导入导出工具--BULK INSERT 和 OPENROWSET

 --使用BULK INSERT导入数据
BULK INSERT db_test.dbo.datatable FROM 'c:/test/aa.txt'
WITH (
  --DATAFILETYPE = 'char',
  FIELDTERMINATOR = ',',  --行分割符
  ROWTERMINATOR = '/n'  --列分割符
)

--SQL SERVER数据导出到EXCEL
insert into OPENROWSET('Microsoft.Jet.OLEDB.4.0','Excel 5.0;HDR=YES;DATABASE=c:/test/aa.xls',sheet1$)
select * from db_test.dbo.datatable

--EXCEL数据导入SQL SERVER
--1.有表的情况
insert into db_test.dbo.datatable
SELECT *
FROM OpenDataSource( 'Microsoft.Jet.OLEDB.4.0',
'Data Source="c:/test/aa.xls";User ID=Admin;Password=;Extended properties=Excel 5.0')...[Sheet1$]

--2.无表的情况
SELECT * into db_test.dbo.datatable2
FROM OpenDataSource( 'Microsoft.Jet.OLEDB.4.0',
'Data Source="c:/test/aa.xls";User ID=Admin;Password=;Extended properties=Excel 5.0')...[Sheet1$]