Parse Lines in a Textbox, Create Individual Records

In this Microsoft Access tutorial, I'm going to teach you how to copy a block of text from something like a document or an email, paste it into your Access database in a text box, and then parse it out line by line and save those as individual records. This is a great technique for pulling email addresses, for example, out of a list of emails you were sent.

Aisha from Evanston, Illinois (a Platinum Member) asks: A couple of times a week, I get an email containing a list of other email addresses from my sales reps that we need to add to our lead generation database. Right now, I'm copying and pasting them individually into their own records, but is there a way I can just select them all and add them all with one shot?

Members

Members will learn how to parse a line that includes more information, for example, first name and last name. Then, we will add a record to the contact table for each new record, indicating a follow-up is needed.

•  01. Free Video
•  02. Extended Cut Video - Silver Members
•  Database Download - Gold Members

Silver Members and up get access to view Extended Cut videos, when available. Gold Members can download the files from class plus get access to the Code Vault. If you're not a member, Join Today!

Prerequisites

• Split Part Numbers: https://599cd.com/SplitPartNumbers
• SQL with Access: https://599cd.com/SQLwithAccess

Links

• Followups: https://599cd.com/Followups

Recommended Courses

• Arrays in Access Developer 21: https://599cd.com/ACD21

Learn More FREE Access Beginner Level 1 FREE Access Quick Start in 30 Minutes Access Level 2 for just $1 Free Templates TechHelp Free Templates Blank Template Contact Management Order Entry & Invoicing More Access Templates

Resources Mailing List - Get emails when new videos released Consulting - Need help with your database Tip Jar - Your tips are graciously accepted Questions? Please feel free to post your questions or comments below or post them in the Forums.

Keywords

access 2016, access 2019, access 2021, access 365, microsoft access, ms access, ms access tutorial, #msaccess, #microsoftaccess, #help, #howto, #tutorial, #learn, #lesson, #training, #database, split text into multiple records, multiple rows, parsing text in Access with VBA, Microsoft Access, parse lines, text box, create individual records, copy text, block of text, paste, database, email, save records, technique, email addresses, list of emails, lead generation, sales reps, one shot, contact table, follow-up, Access database, tutorial