Re: Export to Excel 97-2003 not allowed

Actually, that's not really Excel 5-7. It's BIF. That is, Binary
Interchange Format, a cross platform spread*** format.
Most spread*** 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)

"el zorro" <elzorro@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:85ADCAD3-79A9-49B4-9A6C-54CD53997D99@xxxxxxxxxxxxxxxx
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!


.