access 2000 and paradox(unknown version)

[Rya]

To all;

I have a situation here. I am trying to link an unknown version of paradox to my Access2000. What I got is "external table is not in the expected format". I have installed odbc driver for paradox in my win2000. What to do???

thks.

 

[footpad]

Rya,

It sounds like you're using MS's ODBC driver to connect to the Paradox tables. It could be that the Paradox tables are Level 7 tables. MS's driver only supports Level 5 and older Paradox formats.

You'll need to either obtain an ODBC driver that fully supports Level 7 Paradox tables (also called Version 7) or cast about for a relatively recent copy of Paradox itself and then convert the data to something that Access 2000 fully supports, like DBF or something similar.

Alternatively, you might be dealing with password protected Paradox tables. In that event, you'll need to supply the appropriate password.

For more information, I would suggest posting in the Access for MS Office forums.

Hope this helps...

-- Lance