Importing FoxPro database files from Code

[adame]

I'm trying the automate the import of some FoxPro database file from another application. I'm using the Docmd.TransferDatabase acImport,"xxx" method

But I can not work out what the xxx should be. I've tried FoxPro, Microsoft FoxPro and Fox Pro, but none of them are valid. Can anybody tell me what I should put there? Or does it just not work.

Adam

 

[Tim1]

Adam,

I am not 100% sure, haven't used this facility for a long while, but I think that you need to specify FoxPro and the version (so FoxPro 3.0 etc).

Good luck

Tim