I've read this entire board, but I still have no option to export to "excel"
when exporting. The option just isn't there. I've updated to SP3 rebooted
and still nothing. My colleauges have the same version and can see excel
when exporting. They are using the exact same file also. Any suggestions
why excel is missing from the drop down would be greatly appreciated.

Thank you

What version of Access are you using?

What version of Excel?

You could try doing it in code with something like:

DoCmd.OutputTo acQuery, "qryASAl", "MicrosoftExcel(*.xls)",
"C:\temp\qryASA", True, ""
--
Jerry Whittle, Microsoft Access MVP
Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder.


"Greg" wrote:

> I've read this entire board, but I still have no option to export to "excel"
> when exporting. The option just isn't there. I've updated to SP3 rebooted
> and still nothing. My colleauges have the same version and can see excel
> when exporting. They are using the exact same file also. Any suggestions
> why excel is missing from the drop down would be greatly appreciated.
>
> Thank you
>