exporting Database to CSV in MS Access

[Shiela Mariano]

Dear ALL,

Good day!

Just want to get info how to export a table into CSV without including the time value (00:00:00) under the Date Values.
Hope anyone can help...

Many thanks!

SM ^ - ^

 

[Nikos Yannacopoulos]

Shiela,

Make a query on the table, and instead of the date field as is, use a calculated field like:

FDate: Format([Date Field], "dd/mm/yy")

or whatever the desired format, then export that instead of the original table.

HTH,
Nikos
Dear ALL,

Good day!

Just want to get info how to export a table into CSV without including the time value (00:00:00) under the Date Values.
Hope anyone can help...

Many thanks!

SM ^ - ^

 

[Steve Schapel]

Shiela,

If I understand you correctly, you can export the data from a query, and
instead of the date fields of the query, put something like this example...
DateOnly: Format([Date Values],"dd\-mmm\-yy")
(use your own field name, and required date format).