SQL Server Performance

Error while importing data from Paradox file

Discussion in 'SQL Server DTS-Related Questions' started by morevabs, Jul 6, 2007.

  1. morevabs New Member

    Hi,
    I want to transfer tables from porodox to sqlserver , I have file with *.db format,but during Import wizard ,sql send me this error message

    Error Source:Microsoft JET Database Engine
    Error Description:External table is not in the expected format
    Contex:Error calling open rowset on the provider

    What should I do?
    Please suggest

    Thanks
    Vaibhav

  2. satya Moderator

    Welcome to the forum!

    I believe this is a datatype issue. Make sure that all the datatypes in your SQL Server table match the data type and length of the incoming data.
    Also as you are using paradox I would check whether latest drivers are installed or used here for paradox.

    Satya SKJ
    Microsoft SQL Server MVP
    Writer, Contributing Editor & Moderator
    http://www.SQL-Server-Performance.Com
    This posting is provided AS IS with no rights for the sake of knowledge sharing. Knowledge is of two kinds. We know a subject ourselves or we know where we can find information on it.

Share This Page