34,575
社区成员
发帖
与我相关
我的任务
分享
select count (*) from ( SELECT * FROM OPENROWSET('Microsoft.ACE.OLEDB.12.0','Excel 12.0;Database=D:\DD2018.3.xlsx;hdr=yes;imex=1','select * from [Sheet1$] where 配送日期 <> null and 配送日期 between #2018/8/1# and #2018/8/31#'))
SELECT COUNT(*)
FROM (
SELECT *
FROM OPENROWSET(
'Microsoft.ACE.OLEDB.12.0',
'Excel 12.0;Database=D:\DD2018.3.xlsx;hdr=yes;imex=1',
'select * from [Sheet1$] where 配送日期 <> null and 配送日期 between #2018/8/1# and #2018/8/31#'
)
) AS t
这样可以么?