Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
Update Access Tables from VFP
Versions des environnements
Network:
Windows 2003 Server
Database:
Jet/Access Engine
All,
This is not something I have tried to do before and even after reviewing code samples and articles, I must be extremely thick since it's not sinking in.
There is a remote MS Access database with multiple tables. Variable names and types are "well mannered" with respect to VFP naming conventions and data types. What I want to do is be able to insert new records or replace values in existing records from a cursor of VFP table into the appropriate Access tables.
Let's say that I have A_Data.mdb with tables - Table1 and Table2. Table1 has two text fields Var01 and Var02 of C(50).
Could someone please post a citation or the code to setup the connection and then insert/replace records into Table1 from a VFP table, VFPTable1 ?
Thanks,
Stephen
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