Q: I am having trouble converting from DB format back to DBF. I can convert no problem from DBF to DB, but not the other way. How can I do this. The Error I get is " Database Engine Error: Invalid File Extension" The way I am converting the table is by selecting the table then I click on sort rows or table. I change the format from DB to DBF and select all the fields. This works converting form DBF to DB , not DB to DBF.
A: Use the COPY TO command, thus:
USE tablename.DBCOPY TO tablename.DBF