>I need to copy the contents of an Access database into VFP. I don't know the names of the tables or the columns in each table, so I think I need to know how to do the following:
>1. get the names of all tables
>2. import the contents of each table
>
>Do I need to do this through ODBC? Or is there any other way?
>
>Thanks, Chaim

You have Access 97 you state. If the MDB you have is also Access 97 try the following:

1. Open Access 97
2. Select File
3. Save as Export
4. To an External File or Database - select OK
5. Save as Type - Microsoft FoxPro 3.0

Try this with one table and let me know the results. You should be able to open it with VFP.

Tom