I need to export dates in the format dd-mmm-yyyy (eg 01-JAN-2011) as part of a tab delimited txt file. I cant pass it as a string, it must not have text delimiters in the field. Using Access 2007. text file will be picked up by Oracle application.
Thanks
Andy