Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Converting Access MDB to VFP
Message
De
23/07/2004 17:22:04
 
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00927425
Message ID:
00927471
Vues:
31
This message has been marked as the solution to the initial question of the thread.
Hi Dima,
The MDB is same ODBC source as other, you can use SQL Pass Through functions to access your MDB, or create DBC connection and remote views to your MDB
Connect to MDB using SQLCONNECT()
Then get tables name from MDB with SQLTABLES() it return list of tables for MDB
Then SQLEXEC() for each table "SELECT * FROM..." - it return cursor with data

Its main steps to convert it.

>I have an MDB file but don't know what tables it has. What is the most effective way to convert the entire Access database to VFP?
>
>(I don't have Access so I can't even open the MDB file).
>
>Thank you.
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform