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.
| Author |
Topic |
|
aziltil
Starting Member
1 Post |
 Posted - 2009-04-28 : 20:41:32
|
| I am importing data from an excel file to the SQL Server table. If the excel file contains duplicate rows, how can I eliminate the duplicate row and redirect the errors to another table where as insert the non-duplicates (new) rows or insert into the SQL table.How can we do this in an efficient manner? |
|
|
ravieg2005
Starting Member
1 Post |
Posted - 2009-05-04 : 08:49:14
|
| Hi,We can write SP to import the data from excel to SQL, First we will create tmp table in the SP to store all the data from Excel and from that we can transfer distinct records to SQL table. |
 |
|
|
|
|
|
SSIS delete duplicate rows