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
"It is an important and popular fact that things are not always what they seem. For instance, on the planet Earth, man had always assumed that he was more intelligent than dolphins because he had achieved so much -- the wheel, New York, wars and so on -- whilst all the dolphins had ever done was muck about in the water having a good time. But conversely, the dolphins had always believed that they were far more intelligent than man -- for precisely the same reasons." - Douglas Adams
