DELETE Rows In Excel

• TriggerMe

  SSChampion

  Points: 11752

  More actions

  January 30, 2008 at 5:09 pm

  #183660

  How to delete rows in an excel worksheet?

  I have the following code in the exeutesqltask but i keep getting a syntx error.

  'DELETE FROM 4DialMeters'

  Remeber that this is an Excel source and I need to find out what the correct syntax is for the DELETE Statement in Excel.

  ---

  Kindest Regards,

• Crispin Proctor

  SSCoach

  Points: 18161

  More actions

  January 31, 2008 at 3:00 am

  #773658

  What pray tell is the syntax error?

  To be honest, I don't think you can. I seem to remember doing it through script, not SQL. I may be wrong though.

  Cheers,CrispinI can't die, there are too many people who still have to meet me!It's not a bug, SQL just misunderstood me!

• Frank Bazan

  SSCertifiable

  Points: 5378

  More actions

  January 31, 2008 at 7:10 am

  #773729

  I agree, I think that you'd have to perform a work around... steps would be something like:

  1. Import to a temp table

  2. Manipulate the records in the temp table

  3. Export back to excel overwriting the old file

  Kindest Regards,

  Frank Bazan