Macro to export to excel and NOT keep formatting?

[Jessica103]

I have a query that I need to export to Excel. If I do it through the Export on the menu, I have the option to leave the box "Keep formatting" unchecked...this works perfect. However, I want to create a macro to put on a button (since I don't let the users have the menu) but whenever I run the macro, the file in Excel is formatted. How do I get the macro (or vba code through docmd.outputto) to NOT format the Excel file?

 

[boblarson]

Have you tried using TransferSpreadsheet instead?

 

[Jessica103]

That worked!!! THANK YOU, THANK YOU, THANK YOU!!!