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!
>Thanks!
>Max
--sb--