Hello all,
If have the folling problem. I receive an excel file see below:

Creation Date:Collection Date:Claims number:Status:Date
1/6/2005 1/7/2005 1500205-1 U 1/10/2005 4:11
1/6/2005 1/7/2005 1500205-1 L 1/13/2005 12:14
1/3/2005 1/4/2005 Y35E14N-1 U 1/5/2005 1:56
1/3/2005 1/4/2005 Y35E14N-1 L 1/6/2005 11:54
1/3/2005 1/4/2005 Y35E14N-1 A 1/7/2005 8:44
1/5/2005 1/4/2005 Y400924 U 1/5/2005 0:29
1/5/2005 1/4/2005 Y400924 L 1/6/2005 11:55
1/5/2005 1/4/2005 Y400924 A 1/7/2005 8:44

I need this data in an access database, therefore all the same claim must be on one line. So Claims number must be compaired and it their are equal, the status must be placed one line above behind the date and the date must also be placed one line above and the date aswell. Sometimes there are two equal claimnumber and sometime three. A new claimnumber must start on a new line.
How can help my with this problem?