Results 1 to 3 of 3
  1. #1
    mommyof4kids is offline Novice
    Windows 7 64bit Access 2010 64bit
    Join Date
    Mar 2012
    Posts
    20

    Importing data from Excel to Access...time format

    I have a spreadsheet in Excel that has two times (start & stop times). They are formatted with the TIME 13:30 format in Excel. When I copy the spreadsheet into Access, only some of the records copy for the start/stop times (it is just the start/stop times that are not copying over for some records...everything else copies just fine)



    In the db I have set the Date/Time to Short Time.

    I think it is because some of those records have the time of 24:00...we have 24 hour shifts, the way our payroll shows it as shift ends at on day 1 at 24:00 and starts at 00:00 on day 2...how can I format that start/stop time field to accept the 24: ?

  2. #2
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,521
    when you say 'copy over', you mean ...
    copy/paste?
    or
    importing the excel data?

    importing seems to work perfectly.

  3. #3
    mommyof4kids is offline Novice
    Windows 7 64bit Access 2010 64bit
    Join Date
    Mar 2012
    Posts
    20
    Yes I was copying/pasting into Access...but I have now found the problem...it was in Excel. For some reason even though the format of those cells was set to the time format, it was formatting them as text.

    Problem solved.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Importing excel into access data model
    By aisling21 in forum Access
    Replies: 2
    Last Post: 05-12-2015, 07:03 AM
  2. Importing Excel Data Tables into Access
    By Itch in forum Programming
    Replies: 5
    Last Post: 09-08-2012, 11:27 AM
  3. Importing Data from Excel to Access
    By dkatorza in forum Import/Export Data
    Replies: 3
    Last Post: 11-05-2011, 09:17 AM
  4. Replies: 2
    Last Post: 04-22-2010, 10:40 AM
  5. iMPORTING DATA FROM EXCEL TO ACCESS
    By Rameez in forum Import/Export Data
    Replies: 7
    Last Post: 06-16-2009, 12:05 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums