InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comWed, 19 Jun 2013 14:58:25 GMT20http://www.sqlservercentral.com/Forums/Topic1327014-1292-1.aspxI am trying to do something similar, but I cannot figure out how to close the excel instance from task manager. Any assistance? code snippet belowPublic Sub Main() ' Dim objExcel As Object objExcel = CreateObject("Excel.Application") objExcel.Workbooks.Open("*.xls") objExcel.displayalerts = False objExcel.Sheets("*").Select() objExcel.rows("2:50000").delete() objExcel.Workbooks(1).Save() objExcel.Workbooks.Close(False) objExcel.displayalerts = True objExcel = NothingWed, 10 Oct 2012 12:39:23 GMTsbkotcdhttp://www.sqlservercentral.com/Forums/Topic1327014-1292-1.aspxThanks sneh.it is working fine....Tue, 10 Jul 2012 06:04:17 GMTraghavatgkhttp://www.sqlservercentral.com/Forums/Topic1327014-1292-1.aspxtry using sql script task-Dim filename As String Dim appExcel As Object Dim newBook As Object Dim oSheet1 As Object Dim cell As String Dim rowcount As Int16 appExcel = CreateObject("Excel.Application") filename = "C:\Documents and Settingsbkrrov\Desktop\test.xls" appExcel.DisplayAlerts = False newBook = appExcel.Workbooks.Open(filename) oSheet1 = newBook.worksheets("Sheet1") rowcount = oSheet1.UsedRange.Rows.Count() cell = "A" + rowcount.ToString oSheet1.Range(cell).Entirerow.Delete() With newBook .SaveAs(filename, FileFormat:=56) End With appExcel.Workbooks.Close() appExcel.Quit()ThanksSnehTue, 10 Jul 2012 05:35:52 GMTsnsinghhttp://www.sqlservercentral.com/Forums/Topic1327014-1292-1.aspxHi to all.i didnt got any reply . am i missing any information ?Tue, 10 Jul 2012 05:01:34 GMTraghavatgkhttp://www.sqlservercentral.com/Forums/Topic1327014-1292-1.aspxThanks jitendra. i will try your solution. But i am looking for Script Task.Thanks in advance.:-)Mon, 09 Jul 2012 12:16:25 GMTraghavatgkhttp://www.sqlservercentral.com/Forums/Topic1327014-1292-1.aspx1. Connect to the excel sheet using JET oledb.2. Query the whole sheet and create a datatable which contains the excel data now.3. Delete the first row of Datatable.4. Update the datatable using Dataadapter (This will update the change to excel)ORUse update command as below:update `Sheet Name`set [Column Name]=null where [Condition Column Name] = 'Sample'Mon, 09 Jul 2012 11:57:10 GMTjitendra.padhiyarhttp://www.sqlservercentral.com/Forums/Topic1327014-1292-1.aspxHi to all.I need to delete last row in excel in sheet using ssis task. can any help me regarding this?Please do let me know in case of any additional information required.Thanks in advance.Mon, 09 Jul 2012 11:49:47 GMTraghavatgk