I have a spreadsheet containing hundreds of rows of data to be up-loaded to a database table. The key field in the table is Employee ID. A constraint in the table prevents duplicate Employee IDs. I will upload the data using the SQL Server tool called DTS.
What can I do in Excel (I don't speak VBA) to discover any duplicate rows before I perform the upload? There are too many rows to rely on just scanning by eye.