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.
Wednesday, November 21, 2007
A very fast table copy from SQL Server to MS Access
Posted by Muaddubby at 6:22 AM
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment