Results 1 to 5 of 5
  1. #1
    outdoor is offline Novice
    Windows 11 Access 2019
    Join Date
    Dec 2023
    Posts
    8

    Importing excel .csv date not working

    I have a table that used to work, now it is not. Not sure why. my access table date field is set as date but when i import i get an error. used to work.

  2. #2
    CJ_London is online now VIP
    Windows 10 Access 2010 32bit
    Join Date
    Mar 2015
    Posts
    11,430
    If it used to work, then something has changed

    Can’t suggest anything else without knowing how you are importing and what the error is

  3. #3
    orange's Avatar
    orange is offline Moderator
    Windows 10 Office 365
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,726
    Can you post some data and a copy of your database so readers can "work" with the issue in context?
    We don't necessarily need all data, but sufficient to ensure the "process" works.

  4. #4
    outdoor is offline Novice
    Windows 11 Access 2019
    Join Date
    Dec 2023
    Posts
    8
    Click image for larger version. 

Name:	1.png 
Views:	14 
Size:	93.4 KB 
ID:	51435
    Click image for larger version. 

Name:	2.png 
Views:	12 
Size:	39.1 KB 
ID:	51436Click image for larger version. 

Name:	3.png 
Views:	12 
Size:	17.4 KB 
ID:	51437
    Click image for larger version. 

Name:	4.png 
Views:	12 
Size:	161.7 KB 
ID:	51438
    Click image for larger version. 

Name:	5.png 
Views:	12 
Size:	69.0 KB 
ID:	51439

  5. #5
    Join Date
    Jan 2017
    Location
    Swansea,South Wales,UK
    Posts
    4,940
    So that will be a NO then?
    Please use # icon on toolbar when posting code snippets.
    Cross Posting: https://www.excelguru.ca/content.php?184
    Debugging Access: https://www.youtube.com/results?sear...bug+access+vba

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

Similar Threads

  1. Importing date from excel vba problems
    By mlrucci in forum Programming
    Replies: 5
    Last Post: 02-24-2021, 09:02 PM
  2. Replies: 3
    Last Post: 02-24-2020, 10:22 PM
  3. Working query stops working after importing
    By Abacus1234 in forum Import/Export Data
    Replies: 3
    Last Post: 10-25-2015, 09:12 PM
  4. Importing Excel Not working. Please help.
    By gbarrows in forum Import/Export Data
    Replies: 3
    Last Post: 04-05-2013, 08:13 AM
  5. Replies: 10
    Last Post: 12-28-2012, 02:06 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