Export to Excel 97-2003 not allowed

[Guest]

I have a query that is opened by the user, who then wants to export the file
to MS Excel 2000. To try to automate this process, I added the following line
of code to the command button that runs the query from a form:

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

However, when the user tries to save the file in response to the prompt, the
only option offered is the Excel 5-7 format. If I close the Export screen
that the code brought up and just go to File/Export, then I get the option to
export the file as Excel 97-2000.

So I guess the problem is in my DoCmd code, maybe the "MicrosoftExcelBiff8"
argument. But I don't know how to fix it. Can you help? Thanks!

 

[John Nurick]

This is normal. OutputTo only offers the old format. If you want to
create an Excel 97 workbook you have to use TransferSpreadsheet.

 

[Guest]

Actually, that's not really Excel 5-7. It's BIF. That is, Binary
Interchange Format, a cross platform spreadsheet format.
Most spreadsheet viewers and programs (including Excel
2000) and understand that format but unfortunately Access
does not.

That is, if you export in that format, Access can't re-import.

(david)