>OK,
>
>I'm trying to do simple import of VFP data to a table in SQL 7. Small table - few hundred records.
>
>EVERY time I run through the DTS process - it all works great until the end. I get my VFP source OK - I see the SQL destination OK - I can map the fields just fine. BUT when I get to the end, one of two things seems to ALWAYS happen. Either I get a "application has unexpectadly closed" and I am kicked out, or I click the "finish" button and absolutely nothing happens - in fact - it does a "semi-lock-up" and I end up having to task manger force quite out of Enterpeise manager. Needless to say, the data never gets imported.
>
>HELP!!
>
>TIA,
>Ken
Have you tried the Upsizing Wizard from VFP?