odd- year() stuck in 2000 and 1900

[MCantu]

I have data that looks like this: 3-KJ56, 1-85L6. I am importing data from excel. (This was exporting from another inhouse database program into tabdelimited, into excel, ect)

There are times that I get data that is mistaken for a date:

1-5600 (jan-5600) This is how it is in Excel, before I load it up into access. I use an update Query to correct this mistake

Month([Datafield])& "-" & Year([Datafield])

BUT.....
When Access sees years like "5600" it comes back as "2000" or "8956" comes back as "1956".

When I use the year() statement in Excel, it comes back with the correct year- but not access.

Is there a statement that will force Access to see the entire 4 digit year?

Thanks in advance.

 

[MCantu]

Never mind- solved it- there is no solution

Never mind, I just realized that while the correct "year" exsists in Excel, once uploaded into access, it's converted to text, and the correct first 2 digits are destroyed.