[AccessD] export dates using transfertext A2K

Michael R Mattys michael.mattys at adelphia.net
Wed Apr 9 19:56:01 CDT 2003


Rob,

Stuart gave you a good answer:

Don't export a date, export a text string.
In your queries, create your fields as Fomat$(myDateField,"dd-mmm-yy")

If that didn't work then please post the SQL to your queries.

Michael R. Mattys
www.mattysconsulting.com

----- Original Message -----
From: "Rob Chivers" <rob at consulting.com.au>
To: "Database Advisors" <accessd at databaseadvisors.com>
Sent: Wednesday, April 09, 2003 8:25 PM
Subject: [AccessD] export dates using transfertext A2K


>
> Hi
> I am exporting from a table to a text file with dates but keep getting the
> time in the exported date even though it doesn't appear in the table.
> I have tried setting the date to dd-mmm-yyyy in table field but works on 1
> table but not on another table.
> I have manually set up an export specification (eg
> ExportLeaseSpecification ) for each table using ; delimiter and none for
> text qualifier and : for time separator.
>
> Code is:
> 'following queries export to tmpPASwinExportLease and has 3 date fields
with
> format dd-mmm-yyyy
>     DoCmd.OpenQuery "qappExportLeaseHeader"
>     DoCmd.OpenQuery "qappExportLease"
>     ExportPASwinFile "ExportLeaseSpecification", "tmpExportLease",
> "ExportLease.txt"
>
> The export works fine but results in
>
> 17;21/03/2003;555;;;;;;;;;;;;;;;;;;;;;
> 1;N;070;ca;;;;2;12/04/1999;11/4/2004 0:00:00;;;;0;;;;;;;28/3/2003
14:10:56;
> 2;N;070;cip;;;;2;1/07/2000;30/6/2004 0:00:00;;;;0;;;;;;;28/3/2003
14:10:56;
>
> and what I want is
>
> 17;21/03/2003;555;;;;;;;;;;;;;;;;;;;;;
> 1;N;070;ca;;;;2;12/04/1999;11/4/2004;;;;0;;;;;;;28/3/2003;
> 2;N;070;cip;;;;2;1/07/2000;30/6/2004;;;;0;;;;;;;28/3/2003;
>
> Can anybody help?
>
> Thanks
> Rob
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>


----------------------------------------------------------------------------
----


> _______________________________________________
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>



More information about the AccessD mailing list