exporting delim file

  • Thread starter Thread starter Gals
  • Start date Start date
G

Gals

I'm trying to export a text file frome a query using :
" DoCmd.TransferText acExportDelim "
I hava a problem with a short date fileld thet comes out with the trime :
dd\mm\yyyy 00:00:00 - I need only the date part without
the time .
 
An easy way around it is to create a new query based on the previous one
with no filtering, including all fields of the original but the date field,
and with the addition of a calculated field on the date field like Date:
Left([DateFiled],10)
and export this one instead of the original one. As a result of the Left()
function the date is coverted to text, but for the purpose of exporting to a
text file it makes no difference whatsoever.

HTH,
Nikos
 
Thenk you but now it comes like
"dd/mm/yyyy" i need it without the " " like thate
dd/mm/yyyy
Thenk's again

þþ"Nikos Yannacopoulos said:
An easy way around it is to create a new query based on the previous one
with no filtering, including all fields of the original but the date field,
and with the addition of a calculated field on the date field like Date:
Left([DateFiled],10)
and export this one instead of the original one. As a result of the Left()
function the date is coverted to text, but for the purpose of exporting to a
text file it makes no difference whatsoever.

HTH,
Nikos

Gals said:
I'm trying to export a text file frome a query using :
" DoCmd.TransferText acExportDelim "
I hava a problem with a short date fileld thet comes out with the trime :
dd\mm\yyyy 00:00:00 - I need only the date part without
the time .
Click to expand...
Click to expand...
 
Back
Top