Access 2000 - import FoxPro file

P

Phil

Hi,

I have a form in Access 97 to import a FoxPro file.
Everyhting works fine until the upgrade to Access 2000.
The following is my code in Access 97:

strSelectedProp = Me![ProposalNo]
strDBType = "FoxPro 2.6"
strDBName = "I:\accnting\ "
strSource = "W_" & strSelectedProp
strDestination = "W_" & strSelectedProp

DoCmd.TransferDatabase acImport, strDBType, strDBName,
acTable, strSource, strDestination


After the upgrade to Access 2000, I found out that FoxPro
is not supported by Access 2000 anymore. I can still
manually import the FoxPro file via Table / Import table/
ODBC database. However, I would like to be able to use my
code again or any new modified code to do the importing.
I am totally new to the ODBC.

Thank you.
 
Top