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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Using ODBC import 1
Importing FoxPro 2.6 DBF Into Access 2007 1
Linking a dBase III file with the 'wrong' extension 3
DBF file help 2
import dbf tables 2
Access 2007 Import a DBF file 0
Import MS VisualFoxPro Table into Access database 0
DoCmd.TransferDatabase acImport - an Excel DBF 2

Top