Software

Ask something
Question Locked

Convert Paradox to Access

0 helpful
5 replies

by megahertz

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

I have several Paradox 4.0 tables that I am trying to import into Access 2000. I get the following error message: Unexpected error from external database driver (9737)"

Paradox 3.5 tables import fine.

If I export the Paradox 4.0 table to dbase or ascii or lotus, it imports fine, so I know they are not damaged.

Google, Microsoft knowledgebase etc. all suggest some approaches but nothing useful.
Thanks,

5 replies

by oh smeg

If you have access to Paradox try saving these files in a different Format. They should Import without a Problem though.

The only thing I can think of here is the Version of Office you are using lacks the Backward Compatible Engine to convert these files.

Col

by tony hopkinson

Have a look at what dll access is using to get hold paradox 4 stuff and see if there is a later Acess2000 compatible version.

by megahertz

Access will not open a Paradox 4.0 file if the .VAL file for the same database is present in the same folder.

You will get an error, "unexpected error from external database driver (9737)"

Delete the .val file and it will open fine.

Thanks for all your suggestions.

by tony hopkinson

I wish I could give you a thumb for posting the answer.

I would never have thought of that, and quite obviously nor did the halfwit who did the driver.

This discussion is closed to new replies.