Finally, figured out!!!. We have to select all rows and clear contents and
delete the rows so insert begins at the
first row in first cell. thx
"nkg" <xyz@yahoo.com> wrote in message
news:%23JeeUVKcHHA.4808@TK2MSFTNGP04.phx.gbl...
>I am using opendatasource to insert rows in excel. First i clear the Excel
>sheet all rows to NULL,
> I am noticing that the new rows are always appended from the last
> insertion point in the excel rows.
>
> Is there a way to clear the excel sheet and insert rows from the top of
> the sheet ?
> thx
>