Andrews,

Btrieve files have a .dat extension. If this is your case, the following may give you some ideas.

You could use ODBC or a 3rd party library like dbfTrieve that can access Btrieve files. You could also try Crystal Reports which can access Btrieve files natively.

The problem with Btrieve however is that the file doesn't contain any information about the structure of the data. Btrieve uses DDF files (Data Definition Files) that describe the structures of the tables. The DDF files are used by ODBC and Crystal Report. If you don't have the DDFs you cannot access the file with ODBC.

With dbfTrieve you don't need the DDFs, but you still need to know the structure of the table. There used to be a tool called DDF Sniffer that was analysing a table and based on the pattern "guessed" the structure and allowed you to create the DDFs.

Check out the following site for information about Btrieve (which is now called Pervasive SQL): http://www.pervasive.com/

Here you can find info about dbfTrieve: http://www.hallogram.com/foxpro/

Choosing which method to use depends on your needs. If this is a one time job, I would try ODBC. If you need to interface with Btrieve files on a regular basis, I would use dbfTrieve. I have successfully used dbfTrieve, but it requires some work. Let me know if you choose this path and need some help.

HTH


>Hello alls.
>Has anyone a idea how can I get the information from a .dat file and converting to .dbf file.
>TIA