SELECT *
FROM OPENROWSET( 'Microsoft.Jet.OLEDB.4.0','Excel 5.0;HDR=YES;DATABASE=E:\Downloads\0605加扣款.xls',SHEET1$)
FROM OPENROWSET( 'Microsoft.Jet.OLEDB.4.0','Excel 5.0;HDR=YES;DATABASE=E:\Downloads\0605加扣款.xls',SHEET1$)
SELECT *
FROM OpenDataSource( 'Microsoft.Jet.OLEDB.4.0',
'Data Source="c:\Finance\account.xls";Extended properties=Excel 5.0')...sheet1$
即可
FROM OPENROWSET( 'Microsoft.Jet.OLEDB.4.0','Excel 8.0;HDR=YES;DATABASE=E:\Downloads\0605加扣款.xls','select * from SHEET1$')
--如果接受数据导入的表已经存在
insert into 表 select * from
OPENROWSET('MICROSOFT.JET.OLEDB.4.0'
,'Excel 5.0;HDR=YES;DATABASE=c:\test.xls',sheet1$)--如果导入数据并生成表
select * into 表 from
OPENROWSET('MICROSOFT.JET.OLEDB.4.0'
,'Excel 5.0;HDR=YES;DATABASE=c:\test.xls',sheet1$)