Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Converting Access MDB to VFP
Message
From
23/07/2004 17:22:04
 
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00927425
Message ID:
00927471
Views:
32
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.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform