View Single Post
 
Old 11-30-2006, 01:02 PM
wbiggs2 wbiggs2 is offline
Novice
 
Join Date: Nov 2006
Posts: 1
wbiggs2
Default Help with consolidating multiple records into one

I have a database that has multiple records that I need to reduce down to one record as below:

Input:
SSN name --- ---
SSN --- address ---
SSN --- --- phone
SSN2 name --- ---
SSN2 --- address ---
SSN2 --- --- phone

Output:
SSN name address phone
SSN2 name address phone

It seems that I have the same number of records (6) for each SSN and I am copying the data from each field into the same field position on the output record. I have over 100K records to fix. Can be done in Excel or Access. Data is tab delimited text.

Thanks for your help.
Reply With Quote