Cmdlets for Microsoft Excel

Build 24.0.9060

UseFastInsert Parameter (Connect-Excel Cmdlet)

Indicates whether to use the fastInsert when executing INSERT Statement.

Syntax

Connect-Excel -UseFastInsert SwitchParameter

Data Type

bool

Default Value

false

Remarks

The FastInsert has better performance than the common insert. However, the FastInsert didn't support the INSERT statement with the specified ROWID and would save the insert data into the file after executing INSERT Statement.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9060