I'm trying to export an Access table to a text file but I'm having one issue.

My date should be formatted as "yyyymmdd" and it appears to be until I export it to the text file. Then Access throws the "/" back in.

How can I stop this?