Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Update Access Tables from VFP
Message
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Visual FoxPro:
VFP 8 SP1
OS:
Windows XP SP2
Network:
Windows 2003 Server
Database:
Jet/Access Engine
Miscellaneous
Thread ID:
01150648
Message ID:
01150653
Views:
32
>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

Easiest way is to build a cursoradapter based on Access table. That you could do everything yuou want with it INSERT/REPLACE/DELETE.
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform