Can't import with code 1

[MikeAngelastro]

Hi,<br>
I'm trying to automate the import of a *.dbf file. However, it is not part of a database. Using &quot;DoCmd.TransferDatabase&quot;, I get an error saying that the path is invalid. I believe that this is due to having only a table file and not a whole database. What code could I use to import the table?<br>
Thanks,<br>
Mike

 

[DougP]

Each dBase III and IV file is just the table anyway.<br>
Not sure about version V and beyond.<br>
Can you import it manually?<br>
Click Tables TAB<br>
Right click in white space <br>
Click &quot;Import&quot;<br>
etc.<br>
If So then you have a syntax problem. Paste your Whole Docmd here.<br>
If Not then something else is wrong.<br>
Are you sure it is a Dbase file<br>
Other files have a .DBF such as FoxPro and Clipper<br>
Try importing it manaully using different File types<br>
<br>
Also If you have Excel it will import a .DBF too. See if it will open it.<br>
Then you know what you are dealing with. <p> DougP<br><a href=mailto: dposton@universal1.com> dposton@universal1.com</a><br><a href= > </a><br>