"DaveF" <df*****@geodecisions.com> wrote in message
news:e3**************@TK2MSFTNGP15.phx.gbl...
The problem is there are duplicate rows in the xls. Who can I test the
database against the xls for duplicates
Hi Dave,
First off; this question is probably better suited for either an Excel or
SQLServer newsgroup. You should try there in the future.
But, I just did this Friday, so :
1. Open your xls in Excel and save it to CSV.
2. Import your CSV file into a new table. Don't import directly from an xls
to avoid this problem ...
http://www.sqldts.com/default.aspx?6,222,254,0,1
3. Code your insert statement to use the DISTINCT keyword.
Good luck.
Regards,
John MacIntyre
http://www.johnmacintyre.ca
Specializing in; Database, Web-Applications, and Windows Software