Results 1 to 2 of 2
  1. #1
    albaker is offline Novice
    Windows 10 Access 2016
    Join Date
    Jul 2019
    Posts
    14

    Need to include date stamp of CSV

    I need to import a CSV file with the date stamp of the CSV file appended to each row. These dates do not exist within the CSV file. I've not been able to figure out how to do this, so can anyone give me some direction on where to look? Thanks

  2. #2
    ssanfu is offline Master of Nothing
    Windows 7 32bit Access 2010 32bit
    Join Date
    Sep 2010
    Location
    Anchorage, Alaska, USA
    Posts
    9,664
    Welcome to the forum......


    Check out the function "FileDateTime" in HELP.

    Code:
    Public Sub timedate()
        Dim theFileDate As Date
        theFileDate = FileDateTime("C:\Pullman.csv")
        Debug.Print theFileDate
    End Sub
    Result is -> 2/12/2018 9:49:04 PM

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

Similar Threads

  1. Time/Date stamp Location
    By Western_Neil in forum Database Design
    Replies: 6
    Last Post: 07-10-2016, 09:29 AM
  2. Date and Time Stamp Question
    By NightWalker in forum Programming
    Replies: 12
    Last Post: 06-21-2016, 06:29 AM
  3. Date Stamp when a field is changed
    By winterh in forum Access
    Replies: 1
    Last Post: 04-25-2012, 07:27 AM
  4. Date and Time Stamp
    By zoooza84 in forum Access
    Replies: 2
    Last Post: 08-06-2011, 04:53 AM
  5. Date Stamp On Entry of Record
    By tscholts in forum Forms
    Replies: 3
    Last Post: 04-01-2008, 07:08 PM

Tags for this Thread

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