Exporting Date Fields from Access to Excel

  • Thread starter Thread starter Mark
  • Start date Start date
M

Mark

I have created a query in access that is linked to an
excel spreadsheet.
Several fields in the query are date fields.
Some of the records contain dates and some are blank.
When I synchronize the query results with excel the blank
fields are being returned to excel with a value of zero. I
would like them to be returned to excel with as blank
fields.
Is this conversion performed in excel or access and what
is the best way to solve this dilema?
Please advise.

Mark
 
It's probably being performed by Access, since Access stores dates as 8 byte
floating numbers (the integer part is the date as the number of days
relative to 30 Dec, 1899, and the decimal part is the time as a fraction of
a day).

How are you passing the values back and forth?
 
Doug,

thank you for your response.

the data is only moving from access to excel.

Mark
 
Back
Top