Date format changes when linked to Excel Table

[Guest]

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

 

[Arvin Meyer [MVP]]

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

 

[Pieter Wijnen]

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

HtH

Pieter