Indicates whether to use the efficient insert mode, which forces inserts to append new lines to the bottom of the spreadsheet.

Data Type

bool

Default Value

false

Remarks

When this connection property is set to True, the driver always appends inserted values onto the end and cannot insert rows in the middle of the sheet with the ROWID. This allows INSERT queries to have better performance at the cost of flexibility regarding where rows are inserted. The results of insertions are reflected immediately in the workbook file containing the sheet you're inserting into, regardless of how the BufferChanges connection property is set.

When this connection property is set to False, INSERT queries targeting a specific ROWID are supported. If data already exists on the row corresponding to the ROWID, the driver updates the data -- otherwise, data is inserted in that row.