Can you do the export manually from the query pane or table pane of your Access window? (Should be a toolbar function unless you have customized it out of your default toolbar.)
If it works manually, please post the line of code or the macro arguments you are using to do the export.
If it fails manually, post the error you get from that failure.