Your full service technology partner! 
-Collapse +Expand
Search Access Group:

-Collapse +Expand Access To/From
-Collapse +Expand Access Store

Prestwood eMagazine

September Edition
Subscribe now! It's Free!
Enter your email:

   ► MB LobbyMicrosoft Access BoardAccess VBA Programming Topic   Print This     

How to parse a text file with VBA?

How to parse a text file with VBA? in Access VBA Programming topic (part of our Microsoft Access group).

Quick Search: How parse   How parse text   file VBA  
-- USA
Are there any code examples available somewhere where I could see some guidelines how to parse a delimited text file and change my database accordingly?
 Posted 19 years ago (Thread Starter)
Comment Quote
About TheJoe -Collapse +Expand
Visit Profile
Membership pending.
Member subscribes to this thread but email is NOT VERIFIED.
Email Not Verified!
Once email is verified, we will review and approve the account.
Web Presence Hidden.
Once above is taken care of, full Profile content will display including back links, about me, my message, custom Profile html, social networking links, message board signature, company profile, etc.

Post ID #1439, 2 replies
Thread Started 3/19/2001 10:36:00 PM
View Counter=8258
Location=-- USA 
Joined=19 years ago   MB Posts=6  
Most Recent Post
Brian Prestwood
Prestwood IT
Sacramento, CA USA
First reference the Microsoft Scripting Library in your code. Open the file using the TextStream functionality of the Scripting library. Then use the Split function to break the delimited records up into their elements.

Brian Prestwood, MCSD-MCT
Chief Technology Officer
Prestwood Software

 Posted 19 years ago
Comment Quote
About Brian Prestwood -Collapse +Expand
Visit Profile
Approved member.
Member subscribes to this thread with a verified email.
About Brian Prestwood
Brian Prestwood is the Chief Technology Officer (CTO) of Prestwood Software specializing in .NET distributed business record management system architecture. Currently Brian is focusing on software development work with the state of California. When time permits, he participates in this online community.
Web Presence
Website, My Online Resume (

Post ID #1444 (Level 1.1)  Reply to 1439
Thread Started 3/20/2001 6:42:00 AM
View Counter=2
Location=Sacramento, CA USA  
Joined=20 years ago   MB Posts=12   KB Comments=1  
Beaverton OR USA
If the text file is comma-delimited you might be better off using the wizard provided in Access. Can't recall exactly which menu has it, but it allows you to set up directly to import records from your text file into a table with no VBA. Look at file>external data.

 Posted 19 years ago
Comment Quote
About philmarcus -Collapse +Expand
Visit Profile
Approved member.
Member subscribes to this thread with a verified email.

Post ID #1443 (Level 1.2)  Reply to 1439
Reply Posted 3/20/2001 4:50:00 AM
Location=Beaverton OR USA 
Joined=20 years ago   MB Posts=16  

Revive Thread!

Add a comment to revive this old thread and make this archived thread more useful.

Write a Comment...
Full Editor
Sign in...

If you are a member, Sign In. Or, you can Create a Free account now.

Anonymous Post (text-only, no HTML):

Enter your name and security key.

Your Name:
Security key = P1282A1
Enter key:
Icon: A Post    Thread    Idea    Important!    Cool    Sad    No    Yes    Includes a Link...   
Thread #1439 Counter
Since 4/2/2008
Go ahead!   Use Us! Call: 916-726-5675  Or visit our new sales site:

©1995-2020 Prestwood IT Solutions.   [Security & Privacy]