Did you try DTS?
>I need to copy data from vfp-tables to a sql2000-server. I now use ADO to connect to the sqlserver, to remove data first and then to upload it. I´m surprised by the speed this all takes place. When uploading >50000 records it takes forever. I´m sure this can be done a lot better.
>
>My questions are: how can I upload data with the greatest speed? Is ADO the way to do it. Should I and can I use BCP? If so, how?
>
>Suggestions are appreciated.
>
>Ron
--sb--