I am trying to import data from a set of Paradox tables. For some reason, I
am getting the following error:
Microsoft.Data.Odbc.OdbcException: ERROR [HY000] [Microsoft][ODBC Paradox
Driver] Unexpected error from external database driver (11010).
Could anyone give me any insight on this error (at least a good resource
which will help me to resolve this issue)? I have been searching for a
solution to this problem for quite some time now and I cannot seem to get it
What version of the Paradox is the database?
Have you tried using the Jet provider and Paradox ISAM:
Public Sub ImportParadoxToAccess()
Dim AccessConn As New System.Data.OleDb.OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;"
"Data Source=e:\My Documents\db1.mdb")
Dim AccessCommand As New System.Data.OleDb.OleDbCommand("SELECT * INTO [ParadoxTable] FROM
[Paradox 5.x;DATABASE=e:\My Documents\Paradox].[Paradox5.DB]", AccessConn)
Paul ~~~ XXXX@XXXXX.COM
Microsoft MVP (Visual Basic)