Importing from Paradox?

[shelton1979]

Our company has a nationwide Paradox database which has all the information that could be needed but its accessible to certain users due to restrictions. However, I need to be able to access some of the paradox tables but i'm running office 97 and its on a server. I do not have the drivers for paradox tables to be used inside ACCess..Can someone help me please?

 

[JonFer]

I have Office 97 and Paradox is listed as on option for linking. If you don't see it, it probably wasn't selected as on option during installation. You can add it if you have the Office 97 CD.

 

[shelton1979]

that's the problem. I do not have the CD becaue i'm on network and do not have rights to update my software. Is there another way to go around this?

 

[JonFer]

I am not sure if this is all that is needed to make Paradox an option for linking but you could check if the "mspdox35.dll" file is in your C:\windows\system32\ directory (or wherever the windows OS system32 directory is). If it is, register it by selecting "Run" from the start menu and typing:

regsvr32 C:\windows\system32\mspdox35.dll

I have done this to register the Text ISAM file for some users where it got dropped during a reinstall. If the dll isn't already be on your PC, get it from someone who has the Office CD or your IT people. You're just copying a file so you shouldn't be restricted. Register the dll after copying it.

If that doesn't work, have you tried ODBC?