Getting data from two fields!!!

[Martian262002]

I have this table filled with patient information. I imported the
excel file into textPad, then to Access and I have a little problem.
There are 2 fields that contain Patients name because the names are too
long. How I know where each patient name is because in another field
their is the word Patient, then the next two fields are there name.
Example:

Fields: ServiceDate, PayerID, ServType
Data: Patient, (Lahrmer,), Frances L
03/12/06, WEEK, OT Yaha

The Service Date field is filled with dates, until you reach the next
patient in which it has "Patient" in the field. Same for the PayerID &
ServType!

*Some of the Patients name are in the PayerID field, but others that
are longer are in both!

Question!

How do I get the Patient Name from the PayerID & ServType fields and
put them into a field in the table called PatientName? There are 16,000
records, so typing is not an option!

Thanks in advance!!

Any Ideas!!!!!!!!!!!!!!!

 

[FoFa]

You should have imported right into Access from Excel, why did you go through textpad first?