>I changed the syntax so I am not using m.agloc. Rather I am using magloc. It still fails. The sqlprepare() statement returns the value of 1, so it is fine. but the Sqlexec() statement returns -1. I can not figure out why. I checked to be sure and magloc is not blank or null. It has a value.
>
>So, if anyone has any suggestions as to how I can add these VFP records to an existing SQL Server table , PLEASE suggest.
>
>Marie

You can use aerror() after the sqlexec return -1, then look at the seconed element of the array and you will know why it failed.

Also, if this is a one time thing, to move your data you can use DTS.

Another thing you can do is create a view of the SQL table, then open the view, append the records to the view, tableudate(1) the view.

BOb