thanks, I'll donwload MDAC and give it a try ...
>Have you installed IE5 since installing SQL 7? I had this same problem. If I remember correctly, installing the latest MDAC solved the problem.
>
>>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
Ken B. Matson
GCom2 Solutions