Results 1 to 3 of 3
  1. #1
    Jen0dorf is offline Competent Performer
    Windows 10 Access 2013 32bit
    Join Date
    Jul 2015
    Location
    UK
    Posts
    453

    dates inport from excel

    Hi

    trying to import as spreadsheet with 85000 records


    On field in the spredsheer is designated as text.

    If I import it into access table and specify the field format as short text it imports with no errors but

    aany date with 1900 is converted to a number

    ie

    14/05/1902 in excell becomes in access 865
    07/jun/1902 in excel becomes 889

    yet 30/04/1896 in excel becomes 30/04/1896 in access

    Am I missing something



    thanks

    Ian

  2. #2
    Bulzie is offline VIP
    Windows 7 64bit Access 2007
    Join Date
    Nov 2015
    Posts
    1,463
    Maybe try importing the dates as text fields, then convert them back to date once in Access.

  3. #3
    Jen0dorf is offline Competent Performer
    Windows 10 Access 2013 32bit
    Join Date
    Jul 2015
    Location
    UK
    Posts
    453
    Hi

    thanks for the relply, I ended up changing the format to genera in excel and importing as text, then as you sugested converting to date in access

    cheere
    Ian

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

Similar Threads

  1. Problem exporting dates to Excel
    By Freebird in forum Import/Export Data
    Replies: 2
    Last Post: 07-19-2016, 06:57 AM
  2. ODBC - inport-how many primary keys can i use?
    By HU957 in forum SQL Server
    Replies: 2
    Last Post: 01-08-2015, 08:31 AM
  3. ACCESS VB using Excel Dates Question
    By jscriptor09 in forum Programming
    Replies: 1
    Last Post: 10-11-2011, 07:42 PM
  4. Inport Table from Chinese to English version
    By PatrickC. in forum Access
    Replies: 0
    Last Post: 04-07-2010, 10:19 PM
  5. inport data into invoice from Purchase order database
    By Wrangler in forum Import/Export Data
    Replies: 2
    Last Post: 10-30-2006, 12:28 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