Mark Breen
marklbreen at gmail.com
Fri Mar 30 03:10:56 CDT 2012
Hello John, On the basis that it was you that thought me BCP in 1998, I guess you have considered it. However, I am curious, are you already using it and if not, it is not practical or convenient to use it? Mark On 26 March 2012 17:50, Arthur Fuller <fuller.artful at gmail.com> wrote: > JC, > > You might be able to speed up the import dramatically by using bcp (the > bulk copy utility that comes with SQL Server). I have used it to import > many millions of rows and it's lightning-fast, compared to other tools. > > A quick look in BOL should give you everything you need to know. > HTH, > A. > -- > AccessD mailing list > AccessD at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/accessd > Website: http://www.databaseadvisors.com >