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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top