When I try that it gives an error message stating "Not a table". I've tried "APPEND FROM table.txt" and "APPEND FROM table.dat" but with the same result. What else can I try?
Thanks!
Max

>Take a look at APPEND FROM command. It allows to directly import text files >of different format into predefined cursor/table.

>Good day everyone!
>I was wondering if anyone knows of a program to convert database files. We used to receive data in Visual Fox Pro (.dbf) format and now we receive the information in (.dat) text delimited format.
>Fox Pro won't open this type of file so I was wondering if there was a program that could convert it from .dat to .dbf or if there was a way to work with it in Fox Pro. The only workaround I have found so far is to open the .dat file in Microsoft Excel, convert the text to colums (separated by the '|' symbol and then export it as a dBase file. Please help!