Exporting to CSV

[VegaLA]

Hi all,
i'm having problems exporting a table as a CSV file. Well, actually it works fine but the date field in the resulting CSV file is not formated as short date, instead it shows like so...

7/15/2007 0:00

The code is below.

DoCmd.TransferText acExportDelim, , "tblMk15th", "C:\MyLocation\MyFile.csv"

Is there a way in the transfertext code that I can specify how I want a field to be formatetd ?

Thanks in advance,
Mitch....

 

[Ian Mac]

Why don't you run export it from a query instead, you can use Format(YourDateField,"dd/mm/yyyy") As D
Or you can swap the Day and Month around if you really insist ;-)

 

[VegaLA]

Thank you Ian, that worked a treat !!

Mitch.............