Error while importing data from Paradox file | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Error while importing data from Paradox file

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
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.
]]>