Hi Stephen,
all commands and functions with SqlExec from VFP to MS Access DB must have MS Access syntax.
Check MS Access help.
>>>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?
_______________________________________________________________
Testing displays the presence, not the absence of bugs.
If a software application has to be designed, it has to be designed correctly!
_______________________________________________________________
Vladimir Zografski
Systems Analyst