Results 1 to 2 of 2
  1. #1

    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

  2. #2
    WS Lounge VIP rory's Avatar
    Join Date
    Dec 2000
    Burwash, East Sussex, United Kingdom
    Thanked 187 Times in 173 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.

    Microsoft MVP - Excel

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts