TransferDatabase and FoxPro

[LochDhu]

I am trying to create a macro to auto import FoxPro - what is wrong with this code?

DoCmd.TransferDatabase acImport, "Microsoft FoxPro", "C:\mg_projects\osu\dbf", acTable, "CLP_PROJ.dbf", "TestImport"

I've tried taking off the .dbf extension with no luck - I do not get an error message nor the resulting table. I can run the import wizard within Access and this works fine, just having problems automating this task.

Any suggestions are greatly appreciated,

Thanks.

 

[JoeMiller]

Microsoft FoxPro is not a valid database type in my access installation, I had to pick one of these:

FoxPro 2.0
FoxPro 2.5
FoxPro 2.6
FoxPro 3.0
FoxPro DBC

You can see what types are installed on your system by going into a Macro window, typing TransferDatabase as the Action and clicking the dropdown below for Database Type.

HTH

Joe Miller
joe.miller@flotech.net