xlCellInsertionMode

Specifies the way rows on the specified worksheet are added or deleted to accommodate the number of rows in a recordset returned by a query.

xlInsertDeleteCells	Partial rows are inserted or deleted to match the exact number of rows required for the new recordset (1)
xlInsertEntireRows	Entire rows are inserted, if necessary, to accommodate any overflow No cells or rows are deleted from the worksheet (2)
xlOverwriteCells	No new cells or rows are added to the worksheet Data in surrounding cells is overwritten to accommodate any overflow (0)

xlInsertDeleteCells

Partial rows are inserted or deleted to match the exact number of rows required for the new recordset (1)

xlInsertEntireRows

Entire rows are inserted, if necessary, to accommodate any overflow
No cells or rows are deleted from the worksheet (2)

xlOverwriteCells

No new cells or rows are added to the worksheet
Data in surrounding cells is overwritten to accommodate any overflow (0)