Results 1 to 4 of 4
  1. #1
    carolynafo is offline Novice
    Windows 10 Access 2016
    Join Date
    Jun 2020
    Posts
    3

    Make a table from .txt file using a query

    Hi,
    I'm working on an inventory database. My objective is for a user to be able to easily load new scanned inventory from a Notepad .txt file into the database without having to "go behind the curtain." In other words I want to create a query to upload the data to the inventory file without the user needing to do a paste append. Is this possible?

  2. #2
    Cottonshirt is offline Competent Performer
    Windows 8 Access 2007
    Join Date
    Feb 2018
    Posts
    116
    does this answer your question?


    good luck with your project,


    Cottonshirt

  3. #3
    carolynafo is offline Novice
    Windows 10 Access 2016
    Join Date
    Jun 2020
    Posts
    3
    Hi and thank you...
    I will try it out and let you know if it works for me...
    I REALLY APPRECIATE YOUR HELP

  4. #4
    carolynafo is offline Novice
    Windows 10 Access 2016
    Join Date
    Jun 2020
    Posts
    3
    I have a question for you...
    I made the changes to the code but when i run it, i get an error at the line With Application.FileSearch. the error says "You entered an expression that has an invalid reference to the property FileSearch"

    Any idea why this is happening?

    Btw .what should go in the Const IMPORT_SPEC = "CSV_Import_Spec" line? I changed it to "TXT_Import_Spec" because I'm importing a .txt file to my db. Is that right?

    And again...thank you for your help...

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

Similar Threads

  1. Replies: 4
    Last Post: 04-07-2018, 11:55 PM
  2. Replies: 4
    Last Post: 03-08-2018, 03:27 PM
  3. Replies: 2
    Last Post: 08-12-2016, 07:00 AM
  4. Replies: 2
    Last Post: 02-17-2015, 01:01 PM
  5. Replies: 2
    Last Post: 10-27-2009, 07:09 AM

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