Under the pb (original concept), how to put all of the current database table export to excel (sheet-CodePudding

under the pb (original concept), how to put all of the current database table export to excel (sheet1, sheet2, sheet3... )?
Please master, code, or source? Very urgent, if you have sent to 1489954057 @qq.com source,

CodePudding user response:

The

refer to the original poster arman731 response:

under the pb (original concept), how to put all of the current database table export to excel (sheet1, sheet2, sheet3... )?
Please master, code, or source? Very urgent, if you have the source code sent to 1489954057 @qq.com,

No good way, a table, a table into excel write

Excel by ole connections, and then the table data is copied to the clipboard, and then call paste vba function, and then one by one to realize,