Results 1 to 2 of 2
  1. #1
    Join Date
    Aug 2003
    Posts
    60

    Unanswered: Delete records in SQL table, which are present in Excel

    Hi everyone,

    I have a task to create a dts package, which will delete records in a SQL table, which are present on a sheet tab in Excel. I know how to transfer records from Excel to SQL table and vice versa, but not sure how I can delete the records in SQL table, which are present in Excel. Note that there are just 2 columns - one is a key and the other name.

    Thank you all in advance,
    Saurav

  2. #2
    Join Date
    Jun 2003
    Location
    Ohio
    Posts
    12,592
    Provided Answers: 1
    I would NEVER recommend using Excel as source data for a relational database. You are begging for data corruption.

    At the very least, load the Excel data into a staging table within your database where it can be cleansed and verified before you start deleting production data based upon its contents.

    Bad idea. What is the source of the Excel data?
    If it's not practically useful, then it's practically useless.

    blindman
    www.chess.com: "sqlblindman"
    www.LobsterShot.blogspot.com

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •