除此之外了使用DTS和导出向导外,我们可以利用以下的query进行SQL Server2000与Excel之间数据的导入导出:
insert into OPENROWSET('Microsoft.Jet.OLEDB.4.0',
'Excel 8.0;Database=D:/testing.xls;',
'SELECT * FROM [SheetName$]') select * from SQLServerTable
从Excel导入到新的SQL Server table,
select *
into SQLServerTable FROM OPENROWSET('Microsoft.Jet.OLEDB.4.0',
'Excel 8.0;Database=D:/testing.xls;HDR=YES',
'SELECT * FROM [Sheet1$]')
从Excel导入到已存在的 SQL Server table,
Insert into SQLServerTable Select * FROM OPENROWSET('Microsoft.Jet.OLEDB.4.0',
'Excel 8.0;Database=D:/testing.xls;HDR=YES',
'SELECT * FROM [SheetName$]')
载自:http://www.borlandbbs.cn/first.asp