http://www.thesmartcodes.com/export-ms-access-data-into-ms-excel-from-visual-basic/ [ ^ ]

根据您的要求更改代码，祝您好运：）

http://www.thesmartcodes.com/export-ms-access-data-into-ms-excel-from-visual-basic/[^]
Do change the code as per your requirements, Good Luck :)