Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here


Access button to import text file

Access button to import text file

Access button to import text file


I need help programming a command button in Access 2010 to import a text file; (the code should have the (all range) delimiter) and by pressing the button, Access 2010 reading the text file should produce the file. Once inside Access, the text file updates my queries.



RE: Access button to import text file

Looks like you're tossing out a programming request. If you want help on something specific, you need to ask about that specific portion.

At the very least, you are talking about at least 2 or 3 different things.

What you need to do is:
  1. Focus first on getting the data imported into Access: For instance, what's the original source? Do you really need code to do it? Etc
  2. Then make sure it works - tested it manually various times. Then tell your button to run the code from the form, and ensure it works.
  3. Once you're this far, you can work on the queries you're talking about. What do you mean "updates my queries"? If you're updating a query, then you're generally updating the SQL behind the query. If you're updating actual values, you're updating tables. So once you get there, perhaps start a new question/thread, and give a bit more detail - but work on getting the other items completed before jumping here.

"But thanks be to God, which giveth us the victory through our Lord Jesus Christ." 1 Corinthians 15:57

RE: Access button to import text file

Thank you

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close