Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Strange format of .DBF/.DBT files
Message
 
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
01048208
Message ID:
01048248
Vues:
10
Good point. I don't have Access but I will try Excel. Thank you.

>Excel and Access allow to use this format, I believe.
>
>>I doubt it. Renaming the file does not change the type. But now with Sergey's help I see that the table is dBase IV with memo. So I just need to find a utility or something that will allow me to open the table(s) and convert them to something more up-to-date.
>>
>>Thank you for your suggestion, Naomi (I type that other name first, but then caught myself <g>)
>>
>>>Just a WAG: if you try to rename DBT to FPT would you be able to open it in VFP?
>>>
>>>>I got copies of tables that were maintained by Lotus Approach application. The tables have .DBF and .DBT extensions. And I actually saw a user accessing the tables from Lotus Approach but the message in the windows stating something like "dBase...".
>>>>
>>>>Yet, I cannot open these tables with dBase III.
>>>>
>>>>And when I try to open the tables in either VFP 6 or VFP 8 I get message asking if I want to convert the MEMO to VFP format. If I say yes, I can then open the table but all fields show garbage. That is, it is unreadable. Most data is shown as some high-ASCII characters. If I choose not to convert the memo to VFP format, the message says, "Cannot open table.".
>>>>
>>>>Any suggestions to how I can open these tables and view the data?
>>>>
>>>>Thank you.
"The creative process is nothing but a series of crises." Isaac Bashevis Singer
"My experience is that as soon as people are old enough to know better, they don't know anything at all." Oscar Wilde
"If a nation values anything more than freedom, it will lose its freedom; and the irony of it is that if it is comfort or money that it values more, it will lose that too." W.Somerset Maugham
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform