Importing Text File

Tech-Archive recommends: Speed Up your PC by fixing your registry

I have a text file that I need to import into my Access Database. The problem
is, this is the first report I have come across that has data for one patient
(I work in a hospital) spread over 5 rows. Example:

Name Number Location Visit Date Visit Time
Jim.S 999999
CDA
07/05/05
1400
Sally.G 8888888
CDA
07/05/05
1300

I need to get it into a table like this:
Name Number Location VisitDate Time
Jim.S 999999 CDA 07/05/05 1400
SallyG 888888 CDA 07/05/05 1300

I just know the best way to deal with a report like this. I was thinking I
could write expressions that would list the corresponding location, visit
date, and time with the correct patient....but have had no luck.
I really appreciate any help.
Good night and thank you.
.

Quantcast