sql = "insert into [Inbound Summary] select * from openrowset('Microsoft.Jet.OLEDB.4.0','EXCEL 8.0;HDR=YES;IMEX=1;DATABASE=\\dmnnt508\INPUT.xls', 'select * from [Sheet1$]')
union all--用这个连接
select * from openrowset('Microsoft.Jet.OLEDB.4.0','EXCEL 8.0;HDR=YES;IMEX=1;DATABASE=\\dmnnt508\INPUT.xls', 'select * from [Sheet1$]')"
union all--用这个连接
select * from openrowset('Microsoft.Jet.OLEDB.4.0','EXCEL 8.0;HDR=YES;IMEX=1;DATABASE=\\dmnnt508\INPUT.xls', 'select * from [Sheet1$]')"
sql = "insert into [Inbound Summary] select * from openrowset('Microsoft.Jet.OLEDB.4.0','EXCEL 8.0;HDR=YES;IMEX=1;DATABASE=\\dmnnt508\INPUT.xls', 'select * from [Sheet1$]')
union all
select * from openrowset('Microsoft.Jet.OLEDB.4.0','EXCEL 8.0;HDR=YES;IMEX=1;DATABASE=\\dmnnt508\INPUT.xls', 'select * from [Sheet1$]')"
select * from openrowset('Microsoft.Jet.OLEDB.4.0','EXCEL 8.0;HDR=YES;IMEX=1;DATABASE=\\dmnnt508\INPUT.xls', 'select * from [Sheet1$]')"
是这样吗?
select * from openrowset('Microsoft.Jet.OLEDB.4.0','EXCEL 8.0;HDR=YES;IMEX=1;DATABASE=\\dmnnt508\INPUT.xls', 'select * from [Sheet1$]')
union
select * from openrowset('Microsoft.Jet.OLEDB.4.0','EXCEL 8.0;HDR=YES;IMEX=1;DATABASE=\\dmnnt508\INPUT2.xls', 'select * from [Sheet1$]')
union
select * from openrowset('Microsoft.Jet.OLEDB.4.0','EXCEL 8.0;HDR=YES;IMEX=1;DATABASE=\\dmnnt508\INPUT.xls3', 'select * from [Sheet1$]')"