>prompt% cat large.csv | sort | uniq > small.csv whoa, that's gorgeous bruce, anthony's suggestion is really easy, just import the file into access, then select distinct * into smallcsv from importedcsv rudy