[AccessD] New database from hell

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
>


More information about the AccessD mailing list