Results 1 to 4 of 4
  1. #1
    loquito88 is offline Novice
    Windows 11 Office 365
    Join Date
    Jan 2025
    Posts
    2

    Question Read and import certain data

    I have this request, I have this txt file that has information that I need in my database. The information is always on the same spot. The filename is different every time so I would have to look for the file.Click image for larger version. 

Name:	txt file data.JPG 
Views:	24 
Size:	36.8 KB 
ID:	52624


    The main idea is to get these 3 text segment into my form by extracting and importing data automatically
    Click image for larger version. 

Name:	Fields to transfer data .JPG 
Views:	25 
Size:	55.7 KB 
ID:	52623
    I'm trying to get vba code by pressing a bottom and get data into form. Thanks to anyone that my help me with this. As you could see, Im not and expert in type of situations.

  2. #2
    Join Date
    Jan 2017
    Location
    Swansea,South Wales,UK
    Posts
    6,550
    This sounds very familiar to me.?

    Have you asked this elsewhere?

    Edit: Found it crossposted at https://www.access-programmers.co.uk.../#post-1948014
    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

  3. #3
    loquito88 is offline Novice
    Windows 11 Office 365
    Join Date
    Jan 2025
    Posts
    2

    Unhappy Not workin

    Quote Originally Posted by Welshgasman View Post
    This sounds very familiar to me.?

    Have you asked this elsewhere?

    Edit: Found it crossposted at https://www.access-programmers.co.uk.../#post-1948014
    Yes, but i was not abe to make it work. I did asked for extra help. My apologies if i had to come to this site.

  4. #4
    Join Date
    Jan 2017
    Location
    Swansea,South Wales,UK
    Posts
    6,550
    Well I tested the code you were given first there on a text file of mine. Of course I did not have your text. However it processed the file without any error.
    You should ALWAYS say what the error is, plus ALWAYS advise if you have crossposted, as members here will likely offer the same code that was offered over there.
    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

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

Similar Threads

  1. Read Design & Read Data Issue
    By f15e in forum Access
    Replies: 7
    Last Post: 10-18-2016, 12:44 AM
  2. Replies: 4
    Last Post: 09-02-2014, 11:43 AM
  3. Replies: 24
    Last Post: 07-23-2014, 11:53 AM
  4. Replies: 1
    Last Post: 12-22-2012, 12:38 PM
  5. Replies: 2
    Last Post: 10-19-2006, 04:37 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