Results 1 to 4 of 4
  1. #1
    lucasjkr is offline Novice
    Windows 7 64bit Access 2007
    Join Date
    Nov 2012
    Posts
    7

    Repost: Dates shifting between access and linked excel table

    I posted yesterday and somebody suggested I post a file demonstrating the problem, so here it is.

    In the excel table, you've got a list of dates in 2013 and 2014. The access file links to the database, but all of the dates are shifted to 2008 and 2009. I really don't get it.

    I'm using Excel and Access 2007, on a Windows 7 machine. Any assitance will be appreciated. I'm certain this'll be an easy fix, I just haven't touched access in several years and it's not coming to me.

    ThanksTAP Receivable Tracking.accdbV2 - Copy.zip

  2. #2
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    21,903
    It is working fine for me (Win 7 Pro/Access 2007).

    ExcelDates.pdf
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

  3. #3
    lucasjkr is offline Novice
    Windows 7 64bit Access 2007
    Join Date
    Nov 2012
    Posts
    7
    I actually found the problem, and failed to note it when descibring the issue, as it didn't occur to me.

    I created the workbook on a Macintosh, which apparently uses a 1904 date system rather than a 1900 date system. Excel can translate it without issue (it's a preference you can set by workbook), but Access treats all of the numbers as if they're on the 1900 date system.

    Found it here. I shiould have mentioned the Mac variable, but everything worked fine up until I linked to Access, at which point the problem became apparent and I'd though it was an issue between Excel and Access...

    http://support.microsoft.com/kb/180162

  4. #4
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    21,903
    Glad you got it sorted out.
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

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

Similar Threads

  1. Dates shifting in Linked Spreadsheet
    By lucasjkr in forum Import/Export Data
    Replies: 6
    Last Post: 11-14-2012, 02:45 PM
  2. Question about linked Excel table
    By bgephart in forum Forms
    Replies: 1
    Last Post: 08-23-2012, 11:54 AM
  3. Replies: 6
    Last Post: 05-16-2012, 12:43 PM
  4. Replies: 1
    Last Post: 04-25-2011, 12:36 PM
  5. Replies: 3
    Last Post: 11-19-2009, 09:15 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