>I have been gifted with a bunch of sybase data and I have to import it into SQL. I have tried to import the data using DTS but Get errors regarding data in use. I have loaded Sybase server temporarily on the same machine as a SQL server in hopes of expediating the transfer... I am missing a key element, something small yet paramount.
>
>I need some help as I am under a time crunch.
>
>My thanks in advance,
>Joe
You can get the Sybase data into VFP cursor and then dump it to SQL.
For quick and dirty example, you may create two corresponding connections, create two remote views, get the data from Sybase into one, (optionally do any data manipulations here) add the data to the second remote view from SQL and TABLEUPDATE it.
Nick Neklioudov
Universal Thread Consultant
3 times Microsoft MVP - Visual FoxPro
"I have not failed. I've just found 10,000 ways that don't work." - Thomas Edison