output command results in file deletion instead

[diwin]

I have the following line in a module in access 2010. It was originally written in access 2003.

DoCmd.OutputTo acQuery, "qryOutputForGIS", "MicrosoftExcelBiff8(*.xls)", sPath, False, "", 0

But now, instead of outputting the query, it deletes the destination file. Any ideas?

Daniel Dillon
O o . (<--- brain shrinking at rate shown.)

 

[kjv1611]

Instead of:

DoCmd.OutputTo acQuery, "qryOutputForGIS", "MicrosoftExcel[highlight]Biff8[/highlight](*.xls)", sPath, False, "", 0

Use this?

DoCmd.OutputTo acQuery, "qryOutputForGIS", "MicrosoftExcel(*.xls)", sPath, False, "", 0

Was that a typo?? If not, remove the Biff8 part, I think..

 

[PHV]

I'd try this:
DoCmd.OutputTo acOutputQuery, "qryOutputForGIS", acFormatXLS, sPath, False

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886