Why does 12/3/04 in an Access table become 03-Dec-04 when exporte.

Why does 12/3/04 in an Access table become 03-Dec-04 when exporte.

Post by UmljaCBNSE » Sun, 05 Dec 2004 01:19:10


When exporting a table created in Access with a date formatted as 12/3/2004
to Excel, the date appears as 03-Dec-04 in the Excel spreadsheet. How can I
make the format of the date transfer?
 
 
 

Why does 12/3/04 in an Access table become 03-Dec-04 when exporte.

Post by Douglas J. » Sun, 05 Dec 2004 02:15:30

In many cases, Microsoft products assume mm/dd/yyyy format, ignoring
whatever format you've chosen in Regional Settings.

You say you're exporting the table: to what format are you exporting? How
are you getting it into Excel? If you're using a text file, for instance, I
believe that the Text Wizard in Excel allows you to specify the date format.

--
Doug Steele, Microsoft Access MVP
http://www.yqcomputer.com/
(no e-mails, please!)





12/3/2004
I

 
 
 

Why does 12/3/04 in an Access table become 03-Dec-04 when exporte.

Post by notDav » Wed, 08 Dec 2004 03:53:25

Our solution was to create a query of the table being
exported that includes a column such as this;

OurDate: Format([DateColumn],"mm/dd/yy")

It necessitates creating a query where a table aught to be
enough, but it was simple and it works for us.

~notDave


formatted as 12/3/2004
spreadsheet. How can I