openrowset3.sql

在学习SQL Server过程中整理的T-SQL语句

/*本地excel表导入远程服务器*/


insert into openrowset('sqloledb','4BB8377715894B6';'sa';'sa',elcharge.dbo.ec)
select * from openrowset('MicroSoft.Jet.OleDB.4.0','Excel 5.0;HDR=yes;Database=f:\sqldata\aa.xls','select * from [sheet1$]')