Post reply

Data Comparison for dups

  • February 10, 2006 at 8:27 am

    #189231

    Hi,

    Here is the issue that I am trying to resolve.  I have a spreadsheet that has names and addresses.  I would like to compare the first and last names with records in a sql database, and I would like to automate this process.  I am looking for guidance of how best to resolve this issue.  I am thinking I probably need to use a combination of DTS and Stored procedures, but I am not sure that is the best way.  Any and all details are helpful.

    Thanks

    KR

  • February 10, 2006 at 8:52 am

    #620179

    Import the XLS in a SQL server table. Then use SQL Data Compare (www.red-gate.com) to compare the data.

  • February 10, 2006 at 8:57 am

    #620182

    I am looking more in terms of building something myself to do the comparison - at this time just the first and last names. 

    KR

  • February 10, 2006 at 10:14 am

    #620220

    I think DTS should work fine with this... I have done something like this earlier and I used DTS with different compare and update sql scripts... Good luck!

  • February 10, 2006 at 10:36 am

    #620225

    If it's just 1 simple process, of a single spreadsheet, you can do it all in T-SQL using OpenRowSet:

    SELECT *

    INTO ExcelDataCopy

    FROM  OPENROWSET('Microsoft.Jet.OLEDB.4.0',

       'Excel 8.0;Database=c:\YourServerFolder\YourFile.xls', [Sheet1$])

    You now have a copy of the excel data in a table named [ExcelDataCopy] and can join it as necessary to other tables in your database.

     

  • February 10, 2006 at 1:39 pm

    #620279

    Thanks You all!  You given me a good starting point to work on!

    KR

     

     

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply