Converting a DAT file into a BDF file  
Author Message
FPNewbie





PostPosted: Visual FoxPro General, Converting a DAT file into a BDF file Top

Hello all

I am trying to import a file into FoxPro, it has a DAT extension, is there any way I can convert this to a DBF file

Thanks



Visual FoxPro2  
 
 
Alex Feldstein





PostPosted: Visual FoxPro General, Converting a DAT file into a BDF file Top

Maybe. What is a DAT extension The name itself doesn't tell you anything other than it seems to be a data file, right

What is the program or database used to create it

Do you have a data layout (a structure layout) to explain the data format contained therein

There are no automated tools for this job.

If you have a layout you could conceivably write a small routine to import the data.

Could be a text file (SDF) or maybe a comma-delimited (CSV) file or maybe has some binay and you could use low level functions (e.g. FREAD(), etc.) to import and convert the data.

Unfortunately that's all I can say based on the limited data available.

HTH


 
 
FPNewbie





PostPosted: Visual FoxPro General, Converting a DAT file into a BDF file Top

Hello

My trouble is that I do not have a data layout of the file. It was a COBOL program that created the file.

Thanks


 
 
Sammy Adems





PostPosted: Visual FoxPro General, Converting a DAT file into a BDF file Top

Try to open it with notepad.

Maybe you can parse it as a text file

Sammy.

 
 
Lakshminarayana





PostPosted: Visual FoxPro General, Converting a DAT file into a BDF file Top

.dat may be a text file output from cobol. first try to open in excel and save it as dbf. else if u can findout the layout u can create a dbf and give the following command

use <filename>

appe from <filename.dat> type sdf