Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Mystery Table Import Woes
Message
De
22/01/2006 14:57:32
 
 
À
22/01/2006 14:34:19
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Versions des environnements
Visual FoxPro:
VFP 7 SP1
OS:
Windows XP SP2
Network:
Windows 2000 Server
Database:
Visual FoxPro
Divers
Thread ID:
01089237
Message ID:
01089238
Vues:
29
BDE is the Borland Database Engine. They are dBase IV. You should be able to access them via ODBC.

>I have a set of tables from an unknown database that I need to import into VFP 7. These tables ship with BDE as part of their application and the file extensions are .DBF, .DBT, and .MDX. My immediate assumption was dBase IV, but USE generates a “not a table” message, regardless of SET COMPATIBLE. "SELECT * FROM MysteryTable" also generates “not a table.” "IMPORT FROM MysteryTable TYPE PDOX" (hey, I was desperate) gets me a “Paradox file format is invalid.”
>
>My mama didn’t raise no dummy so I went to ODBC.
>
>nSQLHandle=SQLSTRINGCONNECT("Driver=Microsoft dBase Driver (*.dbf)" + CHR(0) + "DBQ=" + cSrc)
>gets me a connection handle, where cSrc is the data path, but
>
>lnSuccess = SQLEXEC(nSQLHandle, "SELECT * FROM MysteryTable", 'MyCursor')
>
>returns -1 for dBase 3, 4, and 5. No joy in Mudville.
>
>So I fire up Access 2003 and do the File>Import thing with files of type dBase IV, and sure enough, it pulls them right in, no questions asked. So now I could bring them all into Access then from there into VFP, but I’ve got 19 sets of data, and each set has over 300 data files, and I’m too old to deal with all that before I die.
>
>Anybody have any better ideas?
Craig Berntson
MCSD, Microsoft .Net MVP, Grape City Community Influencer
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform