General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
>What's the best way to fix a DBF file that's gone south (get a 'Not a table" message) .
I have had considerable success with opening the dbf file in Excel 97, using the dBase File Type, then saving it elsewhere still as dBase. The only problem is if there is a Date column that has no data at all, Excel sometimes saves it back to .DBF format as text. Solution is to put a date in the column in row #1 and then delete the data via FoxPro. Don't know if this works with Memo fields in the file, as I do not use them.
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only