You can use the Export function in MS Access.Select and Click EXPORT from FILE menu,and then select Excel type as the file type.and input a new Excel file name,click OK. OK?
db.execute "select * into [Excel8.0;database=c:\temp\tab1.XLS].[sheetTest] from [table]"
其中table是你的MDB数据库中的表,tab1.xls是生成的Excel工作簿名,sheetTest是工作表名。欢迎来信探讨