--一次插入很多条的数据
insert into yourtable (col1,col2.......)
select col,col2..... from otherTable当然在存储过程中做也是可以的,--传参数
exec yourSPName P1,P2
insert into yourtable (col1,col2.......)
select col,col2..... from otherTable当然在存储过程中做也是可以的,--传参数
exec yourSPName P1,P2
1.EXEC sp_addlinkedserver 'ExcelSource',
'Jet 4.0',
'Microsoft.Jet.OLEDB.4.0',
'c:\MyData\DistExcl.xls',
NULL,
'Excel 5.0'
GO
2.exec sp_addedlinkedsrvlogin 'ExcelSource','false','sa','admin',null
3.insert into tablbame select * from excel...exceldataSELECT * INTO XLImport8
FROM OPENROWSET('Microsoft.Jet.OLEDB.4.0',
'Excel 8.0;Database=C:\abc.xls',
'SELECT * FROM [Sheet1$]'
SELECT a.*
FROM OPENROWSET('Microsoft.Jet.OLEDB.4.0 ', 'c:\MSOffice\Access\Samples\northwind.mdb';'admin';'mypwd', Orders)
AS a5。SELECT * FROM OPENROWSET('MSDASQL.1','Driver={Microsoft Text Driver (*.txt; *.csv)};Dbq=c:\.....','select * from abc.txt')