Problem Exporting 19th Century Dates To Excel

[jmhoke]

I need to export a large Access table to Excel. Some of the fields in the Access table are date fields, and some of the dates are 19th Century dates (example - 12/15/1899). The problem is - these exported dates appear in Excel as ##########. How do I export 19th centruy dates into Excel? This problem occcurs when I try to export a query of the Access table, and when I use VBA to export the Access table data.

Thanks.

 

[Norie]

Why do you need to export to Excel?

Can you not do whatever you want in Access?

 

[jmhoke]

I need to export the data into Excel as part of a larger project to migrate/convert part of the Access application to Excel. The reason for the migration/conversion is a little complicated.

 

[pritcham]

Hi

Can you not convert the values to text while you transfer to Excel and then deal as you need with at the other end?

Just an idea
Martin

 

[jmhoke]

Thanks for the idea. I had not thought of that. I think I will have to follow your suggestion. I had hoped that there was some easier way around the problem.

 

[SydneyGeek]

Text is the way to go. Excel does not recognise dates prior to 1/1/1900 as dates. They are text anyway (as far as Excel is concerned), and is you try to force them into a date format you will get the problems you mentioned.

Denis