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
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only