General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
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
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only