Results 1 to 3 of 3
  1. #1
    bip54 is offline Novice
    Windows 10 Access 2013 64bit
    Join Date
    Apr 2017
    Posts
    11

    Multiple recordings simultaneously ?


    Hello,
    My wife has an electronic library of several hundred books on a HDD, I make it a small database under Access 2013 (Title, Author, Publisher, Theme, Year, Keywords); I have entered the titles of twenty books and all is well but I would like to know if I can, by making a listing of the file names \ books, record all the list of books at once to avoid the One by one.
    Thanks in advance .

  2. #2
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,549
    you should be able to import your list, then using a query append it into your data table.
    and if needed run an update query to fill in any gaps.

  3. #3
    jwhite is offline Competent Performer
    Windows 10 Access 2013 32bit
    Join Date
    Dec 2012
    Location
    North Carolina
    Posts
    349
    A simple method may be to use the MS-DOS DIR command (use /s if you have subfolders) and send the output to a text file, for example: Dir *.* /S > OutputFileName.txt

    Then read the text file in your code (http://stackoverflow.com/questions/1...e-in-ms-access) and parse the results to then append to your table as needed.

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

Similar Threads

  1. Replies: 6
    Last Post: 03-09-2016, 06:30 AM
  2. Replies: 1
    Last Post: 03-16-2015, 11:06 AM
  3. Replies: 6
    Last Post: 02-21-2014, 04:58 PM
  4. Replies: 4
    Last Post: 07-13-2012, 12:47 PM
  5. Run Multiple Queries Simultaneously
    By Shatterday in forum Programming
    Replies: 1
    Last Post: 03-09-2012, 08:54 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