Hello
Is there an OleDB equivalent to System.Data.SqlClient.SqlBulkCopy ? I need to load an Access database with a fairly large table from an SQL Server source, and no matter how I do it, it's always slower than going directly into Access and doing an import. I have no idea how they do it, but it's fast.
Any ideas? I'm basically getting a reader for the source, and then looping through it. For every record I find, I issue an INSERT command.
Thx,
Is there an OleDB equivalent to System.Data.SqlClient.SqlBulkCopy ? I need to load an Access database with a fairly large table from an SQL Server source, and no matter how I do it, it's always slower than going directly into Access and doing an import. I have no idea how they do it, but it's fast.
Any ideas? I'm basically getting a reader for the source, and then looping through it. For every record I find, I issue an INSERT command.
Thx,