we have a program called FDMS, a funeral home software package, it says
uses Btrieve 6.15 W - it's data files have a *.dat format.

How could I get the data out of these files into Access?

Thanks, Jake

Most likely the easiest way to get the data out is with the
application itself. Double check to see if it has an export function.

Unfortunately the application most likely predates ODBC and has no
ODBC facilities. While there was an ODBC driver (current version for
then) available for that version of the database engine, few
applications used it or provided the SQL/ODBC metadata (record
layouts) required to access the data through ODBC.

The database you have can access the data. The current Pervasive.SQL
engine can also access the data. What is most likely missing is the
database schema stored in DDF files. If you have the *.DDF files then
the current product can export the data (or Access can link to the
ODBC data source). If not it is possible to create the metadata and I
am sure the regulars will chime in on this.

Leonard

On 14 Feb 2005 11:23:42 -0800, rosefh (AT) maqs (DOT) net wrote:

Crystal Reports will work well to export data.

If you need to create the DDF files you can take a look at BtSearch32
at www.nssdd.com. It allows you to analyze the structure and build the
DDF files. Afterwhich it will export to dbase or ascii format.

Gil

Thanks Guys for your responses,
I got my data using BtSearch, very nice program which very easy to use.
Even for a neophyte like me.

Thanks again,
Jake "Jon"
Friendship, WI

Check my white paper on ODBC access from
www.goldstarsoftware.com/press.asp (it should be the first paper listed
there). This explains what it takes to do this.
Goldstar Software Inc.
Building on Btrieve(R) for the Future(SM)
Bill Bach
BillBach (AT) goldstarsoftware (DOT) com
http://www.goldstarsoftware.com
*** Pervasive.SQL Service & Support Classes ***
Coming Soon: Pervasive DataExchange Training!

rosefh (AT) maqs (DOT) net wrote: