Export to Excel

[kadara]

Hi.
I would like to export a query to Excel.
I put a button on a form with the following command line:

DoCmd.OutputTo acOutputQuery, "Query01", acFormatXLS, "C:\Tmp\Test1.xls", True

When I execute this command, the Excel file is opening with the "File error. Some number formats may have been lost" message (the contents of the excel file is OK, not corrupted).

Please help.
Thanks

 

[John Big Booty]

You could try switching the error warning off prior to running the query and then switch them back on once the query has run.

DoCmd.SetWarnings False
DoCmd.OutputTo acOutputQuery, "Query01", acFormatXLS, "C:\Tmp\Test1.xls", True
DoCmd.SetWarnings True

 

[kadara]

It's not working. (I've got the same message).

 

[John Big Booty]

Do you still get the error message if you run the code as;

DoCmd.SetWarnings False
DoCmd.OutputTo acOutputQuery, "Query01", acFormatXLS, "C:\Tmp\Test1.xls", [B][COLOR="Magenta"]False[/COLOR][/B]
DoCmd.SetWarnings True

 

[kadara]

The same problem...
Anytime, when I open the Excel file, appear the error message.

 

[John Big Booty]

So are you saying that if you run the variation on the code I posted in my previous post that the message is suppressed until you physically open the Excel file or that you get the message any way

 

[kadara]

I get the message in that case when I physically open the Excel file.

 

[John Big Booty]

I get the message in that case when I physically open the Excel file.

OK, so that means the error message is originating from Excel. Which is why the DoCmd.SetWarnings command had no effect.

So it would seem that one of the number formats that you are using in Access is not compatible/supported in Excel.