CODEWITHSUNDEEP
ms-access
Raja
Raja

Reputation:

Export Access Database to CSV

I want to export an access database to csv format. When I open up the csv file in excel the dates are messed up. I have one field with the date. The date fields is fine. I have another field with just the time. The time field is messed up. It shows 12/30/1899 with the correct time. Can any help me to get only the seconds in the second field. Thanks.

Upvotes: 0

Views: 712

Answers (1)

Tony Toews
Tony Toews

Reputation: 7882

Use the following expression in the query you are using to create the data:

Format(TimeField, "hh:mm:ss AMPM")

where TimeField is the name of your field which contains the time.

Upvotes: 3

Related Questions