dBase data import problem

  • using sql server 2000 sp2 (at least).

    I am having a hard time import a dBase file into a SQL Server table.  I have indicated that the incoming file is dBase 3, 4, and 5, and I continually get the same message:

    Error Source: Microsoft jet Database Engine.

    Error Description: Unexpected error from external database drive (8961)

    Context: Error calling OpenRowSet on the provider.

    I am done this many times, but I cannot seem to be able to resolve this problem.

    any guidance would be greatly appreciated.

    Russ...

  • I have seen similar errors when one of these is happening:

    a. fieldnames have spaces

    b. fieldnames are over 8 characters

    c. filename is over 8 characters

    d. file is over 2 GB



    Michelle

  • See if this helps:

    http://support.microsoft.com/?scid=kb;en-us;321003&spid=2509&sid=50

    Also, are you sure the file is dBaseIII/IV/V and not FoxPro?  Try using the Visual FoxPro driver and see what happens.

     

  • Problem resolved.  In searching the net I saw that the problem was possibly caused by having some Borland software installed on my PC.  I figured out that the Borland BDE (Borland Database Engine?) got installed on my PC when I installed some vendor software that my users want to use, and I installed it to test it.  I further discovered that the Enterprise Mgr upload would not work when I tried to use Enterprise Mgr. via my PC, but when I worked from the console of the server, it did work.

    I removed the vendor software and the Borland product), and the upload of Dbase files via Enterprise mgr from my PC worked fine.

    Russ...

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply