Syntax for Excel in an Execute SQL Task to drop a specific cell

[HoustonGuy]

I'm trying to delete two specific cells in a ss. (A32 and A33)
I'm using an Exxecute SQL task to do this. I've seen examples online that show this syntax:

Drop Table ['My Sheet Summ$A32:A33'] - The name of my sheet is ['Agent Summary Report-Agent Summ$']

This doesn't work, since it can't find a sheet labeled, My Sheet Summ$A32:A33

So I've tried all alternatives I can think of:

Drop Table ['Agent Summary Report-Agent Summ$'](A32:A33)
Drop Table ['Agent Summary Report-Agent Summ$']A32:A33

etc.

Anyone know what the syntax should be to refer to a cell or cell range?
Here is the web page that I'm using for reference:

Link

Cross posted in the SSIS group.
Thanks in advance!

 

[SkipVought]

hi,

Drop Table drops, er...., uh....., um.....

THE ENTIRE TABLE!

Drop Table ['Agent Summary Report-Agent Summ$']

In Excel the Sheet name IS the table name.

You may need to shorten the sheet name.

 

[HoustonGuy]

Yes i'm aware that drop table drops the table, however from the link I provided it was suggested a cell range could be dropped. If it cant, it cant, but if I'm on the right track I'm asking for syntax help.

Th sheet name length is irrelevant to my issue.

 

[SkipVought]

Well I gave you a solution that removes the entire table from the workbook/sheet.

 

[HoustonGuy]

Yes, I was already aware of that from my testing.
thanks for your input, however.

 

[SkipVought]

Don't forget to post your solution if you arrive at one.

 

[fredericofonseca]

have a look at

http://www.codeproject.com/Articles/37055/Working-with-MS-Excel-xls-xlsx-Using-MDAC-and-Oled

Regards

Frederico Fonseca
SysSoft Integrated Ltd

http://www.syssoft-int.com

FAQ219-2884
FAQ181-2886

 

[HoustonGuy]

Thanks for everyone's input. I never found the syntax for my approach, but I did find an alternative using conditional split.

https://www.simple-talk.com/sql/ssis/moving-data-from-excel-to-sql-server---10-steps-to-follow/

Thanks again!