Export to excel 2010

[billmark]

Hi
My database has been migrated from access 2003 to 2010 and I have vba code to export the report to excel. I want the excel to be 2010 version and change my code:
DoCmd.TransferSpreadsheet acImport, acSpreadsheetTypeExcel9, "New abc_ImportXLS", "C:\Temp.xlsx", False
but I got the message that the format is incorrect. After I changed back to
DoCmd.TransferSpreadsheet acImport, acSpreadsheetTypeExcel9, "New abc_ImportXLS", "C:\Temp.xls", False
it can be exported with compatibility mode.
Please advise how to change the version to excel 2010.

Appreciate your help.

Regards
Bill

 

[arnelgp]

DoCmd.TransferSpreadsheet acImport, acSpreadsheetTypeExcel12, "New abc_ImportXLS", "C:\Temp.xlsx", False