用sa账号登陆sql server 2005 / sql server 2008
运行如下sql语句
exec sp_configure 'show advanced options',1;reconfigure;
exec sp_configure 'Ad Hoc Distributed Queries',1;reconfigure;
创建一个excel表,用excel 2007或者 excel 2010 创建一个excel表:用户表.xlsx
SELECT * FROM OPENROWSET('Microsoft.ACE.OLEDB.12.0','Excel 12.0;Database=D:/用户表.xlsx', 'SELECT * FROM [Sheet1$]')
where 姓名='c'
insert into openrowset('Microsoft.ACE.OLEDB.12.0','Excel 12.0;
hdr=yes;database=D:/用户表.xlsx;','select * from [Sheet1$]')( 姓名,年龄)
select 'c','12f'