I'm using a macro to export data from an Access query to Excel. It works fine but when I open the Excel File I get a dialog that says "File Error. Some number formats may have been lost."
If I click OK everything looks as it should but this is an annoyance I'd like to do away with. I've tried saving to .xls and .xlsx with no difference.
Any Ideas how I can fix this (from within Access preferably)?