export to csv in vba

[jlee]

Can anyone assist me in writing vba code to export an Access table to csv format? I also need help in reformatting the date field to mm/dd/yy in vba code. The original date format in the Access table is m/dd/yyyy.

I was told that you have less problems exporting in code rather than exporting it through Access. Besides, I couldn't figure out how to change the date format if I were to export the table through Access.

Any help would be greatly appreciated!!!

 

[pcs]

do the export with a query and use an expression to do the date formatting.

-----------you wrote------
I was told that you have less problems exporting in code rather
than exporting it through Access.
--------------------------

hmm...access has some pretty powerful tools already built-in...

search help for import/export and specifications.

hth,
al

 

[jlee]

Thanks so much for the reply. Now I got the date formatted correctly but I can't get rid of the time displayed as hh:mm:ss in the csv file. Any idea how to display the date WITHOUT the time?

 

[jlee]

Nevermind! I found this topic discussed in the query section of this forum.

Thanks again.