Creating DBF File form Access Table

[MadJock]

Hi folks,

I am trying to create a dBase IV DBF file from one one of my access tables. I have managed to do this by using a Macro, however, I would rather do it in VBA so that it is more configurable.

The following code is as far as I have got so far:

DoCmd.TransferDatabase acExport, "dBase IV", strdbaseName, acTable, "tblParams", strDestPath

where strDbaseName is the path to my Access Database and strDestPath is the path and name for the DBF I wish to create.

I just keeo getting an 'invalid path' error (the paths are correct, but perhaps not what the method is expecting?). I have looked at the help, but found it rather vague for this method.

Any suggestions would be greatly appreciated.

Thanks,

Graeme website:

http://www.graeme-taylor.co.uk