Importing Pdx 3.5 tables

jmray

unread,

Dec 11, 1998, 3:00:00 AM12/11/98

to

I am trying to import Paradox 3.5 files into Access 97. I have installed the
Paradox driver and changed the ParadoxNetStyle value to 3.x. However when I
try to import I get the error message "External table isn't in the expected
format". I'm not sure what else to do.. Anyone have any ideas??

jm...@cct-nt.com

Robert Farmer

unread,

Dec 14, 1998, 3:00:00 AM12/14/98

to

There are several older conversion programs out in never-never land. Most
of these will convert Pdox to DBaseIII+. I can't think of a program (except
SAS) that won't directly import DBaseIII.

Good Luck
RFarmer

jmray wrote in message <36719...@news3.uswest.net>...

Robert Clement

unread,

Dec 15, 1998, 3:00:00 AM12/15/98

to

jmray wrote in message <36719...@news3.uswest.net>...
>I am trying to import Paradox 3.5 files into Access 97. I have installed
the
>Paradox driver and changed the ParadoxNetStyle value to 3.x. However when I
>try to import I get the error message "External table isn't in the expected
>format". I'm not sure what else to do.. Anyone have any ideas??
>
>

Sorry - No Answer, but I do have the same problem when I try and load or
link a Paradox 5 table. However, I am able to load/link a Paradox 4 table
under the same circumstances.

Steffen Scholz

unread,

Dec 16, 1998, 3:00:00 AM12/16/98

to jmray

We figured out a similar problem with Paradox files. Even if you set
Paradoxnetstyle in the ODBC dialog it won´t be set in the registry correctly.
Try to find the paradoxnetstyle entry in the registry and set it there correct.
Steffen

Joe Hoffman

unread,

Dec 19, 1998, 3:00:00 AM12/19/98

to

I have done Paradox for some time now. Just started to use Access this
year.

I believe the BDE (Borland Database Engine) is the problem. When that Pdox
table
was created the BDE was a version that had an incomatibility bug in it. I
had the
same problem when using Paradox 7 with Pdox 5 version tables

The only way I was able to fix it was to install the newest version of the
BDE so
Paradox will genereate a Pdox table in the correct format by running a query
against your old table and saving the results into a new table. You must
have
Paradox and BDE installed to do this. If your data is not too private nor
too large
zipped, I can offer to convert it for you.

Oh, more possibility. To use the MS ODBC driver:
Pdox table must be 8.3 naming, I.E. employee.db not employees.db and no
spaces.
Up to Pdox table version 5 is supported, cannot use Paradox table version 7

To import it into Access you do not have to go through ODBC, Access can
import it directly certain Pdox table versions. Open you Access db, right
click on
the tables tab, select import, choose the "Paradox (*.db)" from the "Files
of type"
drop down box and point to your Pdox table

BDE updates can be found at
http://www.borland.com/devsupport/bde/bdeupdate.html

Joe Hoffman
hof...@home.com

jmray wrote in message <36719...@news3.uswest.net>...
>I am trying to import Paradox 3.5 files into Access 97. I have installed
the
>Paradox driver and changed the ParadoxNetStyle value to 3.x. However when I
>try to import I get the error message "External table isn't in the expected
>format". I'm not sure what else to do.. Anyone have any ideas??
>

>jm...@cct-nt.com
>
>
>