You must use INSERT.

When you use SQLEXE FoxPro sends your statement to SQL Server, so your statement must be something that SQL Server will understand.


>Sorry, I meant to name the title: appending records with sqlExec(). Should I use insert-sql or append blank and replace?? thanks
>sherry