Information générale
Catégorie:
Codage, syntaxe et commandes
>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
Précédent
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement