When inserting a lot of data into a
SQL Server table, the memory-based bulk copy exposed by the IRowsetFastLoad interface in Microsoft's
OLE DB providers is the fastest way. Here are the steps listed in the example above (with some comments added by me): Establish a connection to the data source. ...
More...