how do i export dates prior to 1900 from access to excel

A

Alan

all dates in my access database prior to 1900 are lost when exporting to
excel, unless i set the field to text not date/time
 
J

John Nurick

Hi Alan,

As I understand it this is a limitation of Excel. But you can still use
Date/Time fields in Access. All you have to do is convert the dates to
text as you export them, using a calculated field in a query, e.g.

fDateField: Format([DateField],"dd/mm/yyyy")
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Display weeks from a Milestone 0
Dates prior to 1900 are text 3
VBA - exporting serial letters to single documents 0
How do I Modify Julian calendar restriction of 1900 2
Exporting pre-1900 dates to Access 1
VBA Export to PDF 0
Access can't export data correctly 1
How to export html text as word document with specific size and orientation 0

Top