HI,

I have emailed the list before regarding this problem.  

When Export a table to a CSV file all the dates change from dd/mm/yyyy
format to dd/mm/yy format.  I have had problems before so the original
dd/mm/yyyy is in text format (when the dates are Date/Time format the
exported date is wrong : dd/mm/yy hh:mm:ss).  Does anyone now how to
export a table from access 97 to a csv file and keep the date format the
same???

TIA

Tim
This e-mail transmission is strictly confidential and intended solely 
for the person or organisation to who it is addressed.  It may contain 
privileged and confidential information and if you are not the 
intended recipient, you must not copy, distribute or take any action 
in reliance on it.  
If you have received this email in error, please notify us as soon as 
possible and delete it.
This e-mail has been scanned using Anti-Virus software, however, 
Swansea NHS Trust accept no responsibility for infection caused by 
any virus received on the recipients system.

In your export specs, under Advanced, check the box for 4 digit year format.
You may also want to check the box for leading zeros whenever it is 1/2/02.
This would change it to 01/02/2002.

HTH,

Beth 

-----Original Message-----
From: Tim Maher [mailto:tim.maher@s...] 
Sent: Wednesday, March 12, 2003 8:24 AM
To: Access
Subject: [access] problems with date when converting to CSV

HI,

I have emailed the list before regarding this problem.  

When Export a table to a CSV file all the dates change from dd/mm/yyyy
format to dd/mm/yy format.  I have had problems before so the original
dd/mm/yyyy is in text format (when the dates are Date/Time format the
exported date is wrong : dd/mm/yy hh:mm:ss).  Does anyone now how to
export a table from access 97 to a csv file and keep the date format the
same???

TIA

Tim
This e-mail transmission is strictly confidential and intended solely 
for the person or organisation to who it is addressed.  It may contain 
privileged and confidential information and if you are not the 
intended recipient, you must not copy, distribute or take any action 
in reliance on it.  
If you have received this email in error, please notify us as soon as 
possible and delete it.
This e-mail has been scanned using Anti-Virus software, however, 
Swansea NHS Trust accept no responsibility for infection caused by 
any virus received on the recipients system.