exporting Database to CSV in MS Access

  • Thread starter Thread starter Shiela Mariano
  • Start date Start date
S

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 ^ - ^
 
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 ^ - ^
 
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).
 
Back
Top