Charlotte Foust
cfoust at infostatsystems.com
Fri Dec 12 11:13:57 CST 2003
You need to do the export from a query and use the format function to change the date to a string of the correct format. If you just export from the table, a date is going to be handled as a date. Charlotte Foust -----Original Message----- From: Oleg_123 at xuppa.com [mailto:Oleg_123 at xuppa.com] Sent: Friday, December 12, 2003 9:05 AM To: accessd at databaseadvisors.com Subject: [AccessD] Exporting to .txt I need to export a file to either .scv or .txt format with fixed length. There are 2 date fields which should be in a mmddyyyy format. I specify in 'specification' that field should have be in a format MDY, 4 digit year. leading zeros, no dividers, yet I still get 12/7/2003 type results... in txt file.. ----------------------------------------- Get Breaking News from CNN, ABC, NBC, CBS Now. http://www.xuppa.com/news/?link=webmail _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com