Date format changes when linked to Excel Table

L

LMsMOM

I have a table in Excel which I've linked to. My last column is a birthday
field, for example 6/18 in the Excel table, with out the year. I do not want
the year entered in this field. When I open the table in Access, the field
becomes 6/18/2008. I've tried formatting in Excel and Access, but still it's
changing. We are not allowed to display a birthyear. Is there a way to keep
this from changing when it's linked.

Thanks,
Sharon
 
A

Arvin Meyer [MVP]

Define the field as Text. Fields defined as Dates are always inclusive of
the year.
 
P

Pieter Wijnen

Build a Query based on the Table & Use Format(MyField, "mm/dd)

HtH

Pieter
 
Top