|
 |
access thread: exporting date fields to csv
Message #1 by "Tim Maher" <tim.maher@s...> on Tue, 21 Jan 2003 13:49:27 +0000
|
|
Hi
Im trying to export a table to a excel CSV file. I have three date
fields in the original recordset, all of which are in dd/mm/yyyy format.
When I try and export to a csv file the dates change to dd/mm/yy
format. Any idea how I can export a table to csv and keep the format
the same.
A nice piece of VB would be greatly appreciated.
Many thanks
Tim
Message #2 by "Richard Gibson" <rgibson@w...> on Tue, 21 Jan 2003 15:38:15 -0000
|
|
What is the short date format on your PC? I think that's what controls the
format that you export to.
-----Original Message-----
From: Tim Maher [mailto:tim.maher@s...]
Sent: 21 January 2003 13:49
To: Access
Subject: [access] exporting date fields to csv
Hi
Im trying to export a table to a excel CSV file. I have three date
fields in the original recordset, all of which are in dd/mm/yyyy format.
When I try and export to a csv file the dates change to dd/mm/yy
format. Any idea how I can export a table to csv and keep the format
the same.
A nice piece of VB would be greatly appreciated.
Many thanks
Tim
|
|
|
View Cart
