I am trying to import a bunch of DBF files into Access tables (well ultimately SQL tables). I understand all the issues with the docmd.transferdatabase command, and that would suit me fine. The problem is that when I run that command my Access database just closes. No error, no feedback. I have tried it with MS Access 2000 and MS Access 2003. I have tried using a variety of the DBF files (all of which open fine in Excel btw). According to the header record, they are dBase III format. I cannot even use the manual "import table" functionality (same result, access closes with no feedback).