Results 1 to 4 of 4

Thread: Date Format
Thanks Thanks: 0 Likes Likes: 0

  1. #1
    Board Regular
    Join Date
    Aug 2011
    Location
    Maine
    Posts
    172
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Date Format

    Hi everyone.

    Can someone please help me. I imported data into access from excel and one of the fields in the new table has date as for example Jul-13 as a text format. Is there a way to convert to normal date?

    thanks

  2. #2
    Board Regular
    Join Date
    Jan 2013
    Location
    Gulargambone NSW
    Posts
    775
    Post Thanks / Like
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)

  3. #3
    MrExcel MVP
    Junior Admin
    Joe4's Avatar
    Join Date
    Aug 2002
    Posts
    50,742
    Post Thanks / Like
    Mentioned
    57 Post(s)
    Tagged
    11 Thread(s)

    Default Re: Date Format

    Can someone please help me. I imported data into access from excel and one of the fields in the new table has date as for example Jul-13 as a text format. Is there a way to convert to normal date?
    It sounds like your dates are probably formatted as Text in Excel, which is why they are also Text when they get to Access.
    There are way do it in Access, but it is a bit cumbersome because you would either need special VBA code to try to change data types and values, or use multiple tables (import to a temporary one, and write to a permanent one).
    The easiest thing to do is convert them in Excel before exporting to Access, using the methods that farmerscott posted.
    TIPS FOR FINDING EXCEL SOLUTIONS
    1. Use the built-in Help that comes with Excel/Access
    2. Use the Search functionality on this board
    3. A lot of VBA code can be acquired by using the Macro Recorder.

    "Give a man a fish, feed him for a day. Teach a man to fish, feed him for life!"

  4. #4
    Board Regular
    Join Date
    Aug 2011
    Location
    Maine
    Posts
    172
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Date Format

    Thank u guys. I will try that.
    Joe, yes the dates are text in excel.

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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