.DB import

[fernando]

Hi,

I'm trying to get data from a paradox file into excel, and
I keep on getting "[Microsoft][ODBC Paradox Driver]
External table is not in the expected format". These *.DB
files are created by another program in paradox format.
While these files are daily used and work perfectly fine,
I can't access them from excel. Importing manually will
throw an error, the following code will open a connection,
but also an error

Dim cn As ADODB.Connection, rs As ADODB.Recordset, _
intColIndex As Integer
Set TargetRange = TargetRange.Cells(1, 1)
Set cn = New ADODB.Connection
cn.Open "Driver={Microsoft Paradox Driver _
(*.db )};DriverID=538;Fil=Paradox 5.X;" & _
"DefaultDir=" & DBFullName & ";Dbq=" & _
DBFullName & ";" & "CollatingSequence=ASCII"
Set rs = New ADODB.Recordset
With rs
.Open "SELECT * FROM " & TableName, cn,,,adCmdText
'>>>>ERRROR<<<<<<

The odd thing is that I don't have any trouble openning
other *.db files. I have Office2003/winXP.

I don't have much experience programing. I would
appreciate some help


thanks

 

[Kalle]

the Paradox file format has like many others too exists in different
versions. Have a look on Borlands Website (This guys support Paradox) You
should be able to read these files by installing Borland Database Engine .
good luck.