reading through a Excel file.

[jhutchings]

I am not sure quite how to begin programming a solution to this problem. I need to take an excel file that has the following headers...

ID1, NAME, ID2, PCPNAME

there are multiple records that have the same ID2.

I need to combine those records so that it would go ID1|ID1, NAME, ID2, PCPNAME

Would my best bet be to import into a dataset and sort on ID2, then when I read the next line, if ID2 doesnt match the previous ID2 then I know I need to create a new record?

Thank you in advance for your help!

 

[Herman]

Why do you need to combine the two rows anyways? Can't you just GROUP BY NAME, ID2, PCPNAME and then treat each row in a group separately? Or do you need to output the combined rows to a file for some other software?

 

[jhutchings]

Why do you need to combine the two rows anyways? Can't you just GROUP BY NAME, ID2, PCPNAME and then treat each row in a group separately? Or do you need to output the combined rows to a file for some other software?

I needed to combine them for another software, but i accomplished this. I ended up using VBA and doing it all through access fairly simply. thank you for the response.