Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
Opening foxpro tables with MS Access
Hi,
Can anybody help me please?
We have an access application here that reads data from Foxpro 2.6 tables. It worked fine in Access97 but we now have a requirement to migrate it to Access 2002 and Access2002 doesn't seem to be able to read the data from the tables.
The import is done automatically within the application, there's no user interaction.
The access application selects fields from Foxpro tables using an sql statement.
openrecordset(Select table.field, table.field2 from)
Part of the sql statement specifies the path to the data
\\folder\folder\folder'[Fox Pro 2.6;]
The Fox Pro 2.6 part tells access which ISAM to use to read the data.
The Fox Pro 2.6 ISAM is no longer supported under Access2002.
Phil.
Suivant
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