Results 1 to 5 of 5
  1. #1
    Akcess is offline Novice
    Windows 7 64bit Access 2013 64bit
    Join Date
    Jun 2016
    Posts
    7

    Import Csv file


    How can I import csv file to myTable and after it updated some required fields/columns from another Table in my DB? I havethe same ID field in csv file I want import and in this another table. For file import I use this VBA code https://www.youtube.com/watch?v=9BeuzRYdw1I&t=3678s

  2. #2
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,521
    Either attach the cvs file as a table, then run an append query to import it,
    or
    run a macro with TransferText to import the cvs file.

  3. #3
    Akcess is offline Novice
    Windows 7 64bit Access 2013 64bit
    Join Date
    Jun 2016
    Posts
    7
    Quote Originally Posted by ranman256 View Post
    Either attach the cvs file as a table, then run an append query to import it,
    or
    run a macro with TransferText to import the cvs file.
    Is it possible in one acction?

  4. #4
    JoeM is offline VIP
    Windows 7 32bit Access 2007
    Join Date
    Jun 2012
    Posts
    3,904
    Is it possible in one acction?
    You can use Macros or VBA to run the whole process with a single click.

  5. #5
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,521
    Once the cvs file is attached you never do it again.
    Just overwrite the previous one,then run the import query.

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

Similar Threads

  1. Import CSV file
    By gg80 in forum Programming
    Replies: 8
    Last Post: 04-08-2014, 09:35 AM
  2. 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
  3. Import Row 1 Only on a .txt File
    By newbie in forum Import/Export Data
    Replies: 2
    Last Post: 02-08-2011, 08:23 AM
  4. Import XML file
    By randolphoralph in forum Programming
    Replies: 1
    Last Post: 01-22-2010, 09:12 PM
  5. CSV File Import
    By compasst in forum Import/Export Data
    Replies: 3
    Last Post: 03-31-2006, 09:37 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
  •  
Other Forums: Microsoft Office Forums