Post reply

SQL Server DTS WIzard Problem Importing from DBF to Sql Server 2000

  • April 6, 2009 at 2:47 am

    #132460

    Dear Sir,

    I am facing a crictical problem while Importing data to Sql Server 2000.

    The scenerio is as follows:

    I had a .DBF file and i want all the data of the DBF to be imported to Sql Server 2000 using DTS wizard.

    The DTS Wizard is throwing the below error.

    "microsoft jet database engine external table is not in the expected format"

    Error Calling OpenRowset on the provider.

    Please provide me with some good solution as it is very urgent.

    Thanks for your Kind Support,

    Regards,

    Mohammad Zubair Pasha.

  • April 6, 2009 at 3:15 am

    #972363

    If that's a Foxpro DBF, you might need to install a driver (free, I think) before this will work.

    The absence of evidence is not evidence of absence
    - Martin Rees
    The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
    - Phil Parkin

  • April 6, 2009 at 3:21 am

    #972365

    Can you Please tell me what is the driver download location

  • April 6, 2009 at 3:31 am

    #972373

    Here looks promising

    http://www.microsoft.com/downloads/details.aspx?FamilyId=E1A87D8F-2D58-491F-A0FA-95A3289C5FD4&displaylang=en

    but I'm no Foxpro guru.

    The absence of evidence is not evidence of absence
    - Martin Rees
    The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
    - Phil Parkin

  • April 6, 2009 at 3:45 am

    #972382

    Dear Sir,

    I have installed Microsoft Foxpro Drivers and selected the DSN Driver as Microsoft Fox Pro driver (*.dbf) and it worked fine.

    Thanks for your support.

    Regards,

    Mohammad Zubair Pasha.

  • April 6, 2009 at 3:59 am

    #972391

    That is good news - thank you for the feedback!

    The absence of evidence is not evidence of absence
    - Martin Rees
    The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
    - Phil Parkin

Viewing 6 posts - 1 through 5 (of 5 total)

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