Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
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
>
>
>TEXT TO sqlcommand TEXTMERGE NOSHOW
> INSERT INTO Table1 VALUES('first','second')
>ENDTEXT
>
Vladimer,
This works! However when I chnge the above line to
INSERT INTO Table1 FROM MEMVAR
I get an ODBC connectivity error. I vaguely recall that there is something special that needs to be done with the TEXT TO command to perform something like macro substitution.
Any hints?
Précédent
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