How to combine Records in Access?

[alpine]

I receive a .dbf file containing student information on a daily basis. For simplification purposes, it contains the following information:

Name..........S tudent ID #........Exam 1..Exam 2..Exam 3

Michael Smith....1..... ...........95
Jane Johnson.....5.. ............... .......98
Ana Jordan.......3. ............... 92 [exam 1]
Ana Jordan.......3. ............... ........97 [exam 2]
Ana Jordan.......3. ............... ............... .90 [exam 3]
John Michael.....11. ............... .......85
Shawn John.......15.. ............... ......90 [exam 2]
Shawn John.......15.. ............... ..............9 8 [exam 3]

If a student takes more than one exam, his or her record is duplicated and each row contains the score of a different exam. This results in multiple records for each student.

I save this file as an Excel file and import it into Access 2002. The Excel file is linked, so when I receive a new file the following day, I just update the Excel file.
However, I do not want a separate record for each student. I want it to look as follows:

Name..........S tudent ID #........Exam 1..Exam 2..Exam 3

Michael Smith....1..... ...........95
Jane Johnson.....5.. ............... .......98
Ana Jordan.......3. ............... 92......97..... .90
John Michael.....11. ............... .......85
Shawn John.......15.. ............... ......90......9 8

How do I get Access to do this?
What kind of query would be required?

[beacon]

Does your Excel file actually say [exam 1], [exam 2], and [exam 3] for those students that have a grade for an exam?

If so, I can help you out.

Without the identifier after the grade, I could setup a query that sets up like you want, but right now it would require you to have a blank record entered for each student ID. There may be ways around this, but I'm not familiar with them.

[alpine]

thank you for your reply. i need to check a few things before i can respond.
thanks again.