Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Convert a ".DAT" type file to a ".DBF" for FoxPro 2

Status
Not open for further replies.

JmichaelSR

Programmer
Mar 17, 2004
15
US
I have a Data file (type .DAT)that I would like to include in a FoxPro 2.5 query. Is there an easy way to convert this file to a DBF file for use in Foxpro?

Any suggestions would be appreciated.

Thanks,

Mike Clark

Mike Clark
Programmer/Analyst
Mississippi State Fire Academy
 
It depends on what the .DAT file consists of, or is used by.
If you can determine the format of the file, you can parse it. Or it may be able to be accessed using OLE or some process.
You may also be able to use the host application to export it to a format directly accessible by Foxpro.


-Dave Summers-
[cheers]
Even more Fox stuff at:
 
Try to open the file with Notepad or with MODIFY FILE in FoxPro. Chances are, it will turn out to be a Fixed Width or Delimited text file, in which case you will be able to use APPEND FROM ... TYPE ...
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top