General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Update Access Tables from VFP
Environment versions
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
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