[AccessD] export dates using transfertext A2K

Rob Chivers rob at consulting.com.au
Wed Apr 9 19:25:33 CDT 2003


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














-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://databaseadvisors.com/pipermail/accessd/attachments/20030410/8f40b564/attachment-0001.html>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://databaseadvisors.com/pipermail/accessd/attachments/20030410/8f40b564/attachment-0001.htm>


More information about the AccessD mailing list