Importing Foxpro table

[Phil]

Hi,

I am a normal user of Access 97. I use macro action
(transferdatabase) to import a FoxPro table into Access
from my computer. It works fine because I can select the
FoxPro from the database type field. However, there is a
problem when I used my co-worker’s computer. The FoxPro
option is not available for database type field. I have
already checked the window/control panel/OBDC data source
(32 bit)/User DSN. Both computers have the followings:

 FoxPro file
 Visual FoxPro database
 Visual FoxPro tables

Honestly, I have no idea what they mean. I just tried to
compare them to see if there is any difference.

I am very appreciated if you can show where to start.

Thank you.

 

[Joe Fallon]

Try re-registering the dll files like this:
Start Run
regsvr32 msexcl35.dll
regsvr32 msxbse35.dll
regsvr32 mspdox35.dll
regsvr32 mstext35.dll

Use 40 instead of 35 for A2K and 2002.

That's MSEXCL35.dll not MSEXC1.dll.

Foxpro may use the msxbse.dll for Fox and dbase.

 

[Phil]

Joe, thank you so much.

It works fine now.

Thank you.