Results 1 to 3 of 3
  1. 08-04-2022, 10:59 AM #1
    Sonyat810
    Sonyat810 is offline Advanced Beginner
    Windows 7 64bit Office 365
    Join Date
    May 2022
    Posts
    37

    Is it possible to strip out time in access using a .csv file

    I have a file and when I enter the data it returns the timestamp. I have imported a linked .csv file and nothing seems to work.
    Reply With Quote Reply With Quote
  2. 08-04-2022, 11:21 AM #2
    Welshgasman
    Welshgasman is offline VIP
    Windows 10 Access 2007
    Join Date
    Jan 2017
    Location
    Swansea,South Wales,UK
    Posts
    4,914
    Crossposted after 30 plus posts.
    https://www.accessforums.net/showthr...t=86402&page=3
    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
    Reply With Quote Reply With Quote
  3. 08-05-2022, 05:28 AM #3
    ranman256's Avatar
    ranman256
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,524
    Convert it in the append query.
    Reply With Quote Reply With Quote
Please reply to this thread with any new information or opinions.
« Previous Thread | Next Thread »

Similar Threads

  1. Store current date/time in a table each time Access file structure is changed and saved
    By scienceguy in forum Programming
    Replies: 6
    Last Post: 12-09-2019, 05:34 AM
  2. run-time error 2220. can't open the file. but the file exist
    By ringram in forum Forms
    Replies: 1
    Last Post: 11-28-2014, 06:56 PM
  3. Strip Security from Access 2003
    By agarvan in forum Access
    Replies: 4
    Last Post: 08-13-2013, 11:05 AM
  4. Import Excel file based on a date and time in file name
    By nhylan in forum Import/Export Data
    Replies: 4
    Last Post: 04-16-2013, 03:26 PM
  5. real-time data integration of csv file into access
    By nlsoe in forum Import/Export Data
    Replies: 4
    Last Post: 10-17-2012, 06:57 AM

Posting Permissions

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

Forum Rules

Other Forums: Microsoft Office Forums