DELETE Rows In Excel

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » SQL Server 2005 Integration Services » DELETE Rows In Excel

DELETE Rows In Excel

Rate Topic

Display Mode

Topic Options

Author

Message

TriggerMe

Posted Wednesday, January 30, 2008 5:09 PM

SSC Eights!

Group: General Forum Members
Last Login: Tuesday, April 30, 2013 11:19 PM
Points: 871, Visits: 273

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,

Post #449752

Crispin Proctor

Posted Thursday, January 31, 2008 3:00 AM

SSC Eights!

Group: General Forum Members
Last Login: Tuesday, April 16, 2013 8:31 AM
Points: 917, Visits: 399

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,
Crispin

I can't die, there are too many people who still have to meet me!

It's not a bug, SQL just misunderstood me!

Post #449841

Frank Bazan

Posted Thursday, January 31, 2008 7:10 AM

SSC Veteran

Group: General Forum Members
Last Login: Wednesday, March 06, 2013 3:02 PM
Points: 268, Visits: 1,055

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
@Bikeride2Africa

Post #449929

« Prev Topic | Next Topic »

Permissions