I've got a text doc that is formatted like this:
ABC Company
1234 Main Street
Los Angeles, CA 92022
213-555-1212
Employees: 5
John Doe
XYZ Company
2552 Easy Street
San Diego, CA 92066
760-555-1212
Employees: 8
Jane Doe
and so on. How do I get this data into access where it will take this data and format it into columns where each line is a separate company?
Thank you in advance for your help!!!