Another option ;-)
I will take a look at this one.

Thanks,

Ron

>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