Link to home
Start Free TrialLog in
Avatar of AntiBook
AntiBook

asked on

Import txt file into access

I have a large txt file over 50K rows contains information formatted as in the code. How do I use vba to import it into a table in Access? Each block is separated by "---"

Thanks
Name:            John Doe
ID Number:       123abc
Dob:      2/1990
Code:             111
Username:          user1
Code(2):        abc123
E-mail:            jd@yahoo.com
Address: 
  Name:            John Doe
  Address:         123 Main St.
                   New York, New York, 12345 United States

---

Open in new window

Avatar of Patrick Matthews
Patrick Matthews
Flag of United States of America image
Please upload a sample text file.  It does not have to be the complete file, but it does have to show all of the various nuances your source data can have.

Please sanitize the data as needed to protect privacy/confidentiality.
Avatar of AntiBook
AntiBook

ASKER

please see the attached
sample.txt
ASKER CERTIFIED SOLUTION
Avatar of als315
als315
Flag of Russian Federation image
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of AntiBook
AntiBook

ASKER

Thanks a lot