Results 1 to 3 of 3
  1. #1
    Lounger
    Join Date
    Jan 2001
    Location
    Seymour, Connecticut, USA
    Posts
    33
    Thanks
    0
    Thanked 0 Times in 0 Posts

    excel dates to access dates

    when i convert an excel database to access the dates change to an access format. Is there a way to retain my mm/dd/yyyy format or convert it from the access format back to mine?

    Thanks in advance

  2. #2
    5 Star Lounger
    Join Date
    Mar 2001
    Posts
    989
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: excel dates to access dates

    In Access highlight the table and click on Design on the right. Move the cursor to the field you want to change. In the Format property in the list of Field Properties underneath type your custom format.

  3. #3
    Uranium Lounger
    Join Date
    Jan 2001
    Location
    South Carolina, USA
    Posts
    7,295
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: excel dates to access dates

    Both Excel and Access store dates the same way, a numeric value that is the number of days since 12/31/1899 (a value of 1 is 1/1/1900). What you need to do is open the Access table containing the date in design mode, select the field containing the date, and then change the fields display format to be whatever you want it to be.
    Legare Coleman

Posting Permissions

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