Results 1 to 2 of 2
2001-11-20, 11:34 #1LynneGuest
Date conversion problem excel to Access (Access 97)
<img src=/S/help.gif border=0 alt=help width=23 height=15> Calling all knights in shining armour
I have converted a list of employee information from excel into access. All the text converted ok but the date has come out a one long number instead of a date format. eg 12/5/00 has converted into 36558. Does anyone know how ie can convert this back into a date format. I have over 7000 records so it wold be a long job to do manually.
Can someone help me please????????????????? Damsel in distress
2001-11-20, 13:22 #2
- Join Date
- Dec 2000
- Burwash, East Sussex, United Kingdom
- Thanked 191 Times in 177 Posts
Re: Date conversion problem excel to Access (Access 97)
You should be able to do this simply by changing the field type from number to date. I would recommend taking a backup copy of your table (or your database) before you do this just as a precaution. I have only tried this in Access 2000 as I no longer have 97, hence my note of caution.
Hope that helps.Regards,
Microsoft MVP - Excel