[AccessD] export dates using transfertext A2K

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

On 5 Apr 2003 at 11:21, Rob Chivers wrote:

> 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
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 


-- 
Lexacorp Ltd
http://www.lexacorp.com.pg
Information Technology Consultancy, Software Development,System Support.