Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  SQL Server 2005 Forums  SSIS and Import/Export (2005)  Filter Excel table to remove duplicates

Author  Topic  tmccar Starting Member 27 Posts Posted - 2011-11-25 : 08:18:03 I have 2 excel spreadsheets, which have a common column, "drawing number". One file has 51 columns and over 100,000 records and the other has just one column and 68,000 rows. The single-column file has all unique records, whereas some drawing numbers are repeated in the large file. I would like to generate a third file which is filtered using the single column, which has 51 colums and 68,000 rows. How can I filter the large file with the smaller, so that only the first occurrance of the drawing number is output to the new file. (All subsequent ones can be ignored)?