I have a text file having thousands of records, each one six (6) lines long as shown below:
City, State Zip
Any idea how I might import the above information into either Excel or Access such that each record is stored as follows?
[Name] = Last, First
[Street] = Street
[City] = City
[State] = State
[Zip] = Zip
[E-mail] = E-mail
[Web] = Web
Each line of the text file is terminated with a <CR> and there are no extraneous lines between unique records.
I know how to import this info rather easily if all of the fields were comma delimited with each record on a separate line but I can't see how to do this if each record spans multiple lines.
Thanks in advance for any-and-all assistance.