import foxpro table to access

[xkidd]

i get a reserved error -7778...trying to import fox pro tables into access 2000...i also get a message stating external table not in expected format...
any ideas??

 

[nice95gle]

I had this problem once and I used the following acticle to help me out.

http://support.microsoft.com/default.aspx?scid=kb;en-us;212886&Product=acc2000

 

[xkidd]

what do they mean by Use a Machine DSN (that is a User or System DSN) instead of a File DSN...
i think i did it like they are saying..but its still not showing up..this thing is driving me crazy!!

 

[xkidd]

ok..i loaded a new driver for fox pro tables..but its listed under user..not system...how do i get it under system so i can set up the data source??

 

[nice95gle]

if you click on the system tab in ODBC Admin you can then Add the reference to the foxpro driver there.

 

[xkidd]

this is still not working...it will create a source to the actual dbc file not the dbf file...is there a way to import the dbf files straight from the directory??

 

[nice95gle]

The last thing you should check is the driver version you are using.

Keep in mind that the regular foxpro driver is no longer supported by microsoft. You would need the visual forxpro driver

Version "6.01.8629.01" or above
File "VFPODBC.DLL"

I don’t know if this effect anything but depending on the version of Access you are using it might.

here is an article I can across in my searches when I was having a problem with this same issue.

http://support.microsoft.com/defaul...port/kb/articles/q235/3/57.asp&NoWebContent=1

Good Luck