如何将所有工作表中的所有新行复制/粘贴到新工作表？ [英] How Do I Copy/Paste All New Rows From All Worksheets To New Worksheet?

问题描述

如何将所有工作表中的所有新行复制/粘贴到日期为> 28/03/2014的新工作表？

How do i Copy/Paste all new rows from all worksheets to new Worksheet where the date is =>28/03/2014?

推荐答案

您可以使用 ADO.Recordset [ ^ ]和< a href =http://msdn.microsoft.com/en-us/library/office/ff839240%28v=office.14%29.aspx> Range.CopyFromRecordset [ ^ ]方法。



此处 [ ^ ]你会找到MS Excel文件的正确连接字符串。



命令如下所示：

You can use ADO.Recordset[^] and Range.CopyFromRecordset[^] method.

Here[^] you'll find the proper connection string to MS Excel file.

The command would looks like this:

SELECT *
FROM (
    SELECT Field1, Field2, ... FieldN
    FROM [Sheet1

UNION ALL
SELECT Field1，Field2，... FieldN
FROM [Sheet2

UNION ALL SELECT Field1, Field2, ... FieldN FROM [Sheet2

UNION ALL
SELECT Field1，Field2，... FieldN
FROM [Sheet3

UNION ALL SELECT Field1, Field2, ... FieldN FROM [Sheet3

这篇关于如何将所有工作表中的所有新行复制/粘贴到新工作表？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！