MS Access export date in the format: 01-Mar-2006

[Guest]

I am trrying to export an Access database with the date format: 01-Mar-2006.
Access allows me to have the format in a table, but when it comes to
exporting, the allowable date formats are limited. Currently I export from
access, open in Excel, and change the date format.

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/com...-9bbd-2abe9b81f373&dg=microsoft.public.access

 

[John Vinson]

I am trrying to export an Access database with the date format: 01-Mar-2006.
Access allows me to have the format in a table, but when it comes to
exporting, the allowable date formats are limited. Currently I export from
access, open in Excel, and change the date format.

Use a calculated field in a Query: type

ExpDate: Format([datefield], "dd-mmm-yyyy")

into a vacant Field cell. Export from this query rather than directly
from the table.

John W. Vinson[MVP]