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 Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

How to Create .DBT file on a .DBF file

Status
Not open for further replies.

SCrystal

Programmer
May 7, 2002
14
0
0
US
I have two set of files

Many Files : CO.DBF, CO1.DBF ... files with .DBT files
One Files : OP.DBF file with .FPT file

I have to convert the .FPT file to .DBT file OR
I have to create .DBT file on OP.DBF how can I do it.

Basically I want to have all files in same format i.e. .DBT for memo fields as I have to create reports based on these files which right now is not possible.

Is there any way to convert or create the above file.
 
You don't say which version of dBase you are using.
though they pretty much are all the same in this regard. A .dbt file is the memo portion of the dbf file. If you create a table with a memo field dBase automatically creates the dbt file. You don't actually create the dbt - dBase does.

Marc
 
I am using dBbase 5.0. The real problem is there is only one file out of all the files which has a .FPT memo file and rest files have .DBT memo files.

I want to create reports based on this in Crystal Reports but I am not able to create it due to dBase and FoxPro difference.

Is it possible to delete .FPT file and create .DBT file on the existing .DBF file.

I have to use dBase and Foxpro ODBC drivers to access these files. When I try to create a single report using these two different ODBC connections it does not fetch the data.

 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top