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.