import/link DBF file

G

Guest

I am trying to import or link a list of DBF files. The
code I use is like this:

DoCmd.TransferDatabase acImport, "dBASE
5", "G:\DETAILS\ACCSUM\040301AA.AAA\ACCSUM1.DBF",
acTable, "ACCSUM1", "test"

An error message comes up when running it: "The dBASE 5
type isn't an installed database type or doesn't support
the operation you chose." There is no problem if I import
it from menue. But I need automated solution from coding.

Any help is greatly appreciated!

Thanks,

Shirley
 
Top