Google
 

Wednesday, November 21, 2007

A very fast table copy from SQL Server to MS Access

New article coming up ...

I've recently fought (and won) a battle to get the fastest possible copy of a table from SQL Server to MS Access within a C# project. I tried the usual things like SSIS and ADO.net, but the fastest thing was the import utility within Access itself. I finally go it to work properly, and it flies (it's an average of 20 - yes 20 - times faster than copying through SSIS or other widely used methods). I'll post the article in the coming days.

No comments: