Can't export to EXCEL file

G

Greg

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
 
J

Jerry Whittle

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, ""
 
Top