External Table is not in expected Format

• Muhammad Jamil Nawaz

  Grasshopper

  Points: 23

  More actions

  October 1, 2006 at 7:39 am

  #76592

  Hello Everyone,

  I am creating a DTS package in SQL Server 2000, Package do the exporting of data from paradox to ms access. But i got error "External Table is not in expected Format".

  I try it in other many differnet ways but same error message comes out.

  I try in a way that i create link tables in ms access, when i open link table in ms access then it opens it fine but when i try to access that link table data from my c# programm by using simple OLEDB command, i got the same error.

  Please help me as soon as possible.

  Regards,

  Jamil

• Michael Tocik

  SSCertifiable

  Points: 7175

  More actions

  October 2, 2006 at 6:21 am

  #663554

  Hi

  Have you tried dumping to a text file then importing the text file?

   

  Mike