没有员工编号,公司重名的话目前倒是没有
我又重新有了SQL语句汇总,但是汇总结果是例如出勤天数只计数显示结果,求和结果就是零,
具体SQL语句如下:
SELECT * FROM [Sheet1$] UNION ALL
SELECT * FROM [Sheet2$] UNION ALL
SELECT * FROM [Sheet3$] UNION ALL
SELECT * FROM [Sheet4$] UNION ALL
SELECT * FROM [Sheet5$] UNION ALL
SELECT * FROM [Sheet6$] UNION ALL
SELECT * FROM [Sheet7$] UNION ALL
SELECT * FROM [Sheet8$] UNION ALL
SELECT * FROM [Sheet9$] UNION ALL
SELECT * FROM [Sheet10$] UNION ALL
SELECT * FROM [Sheet11$] UNION ALL
SELECT * FROM [Sheet12$]