I have to copy a very large number of records to an existing table on a SQL Server from a VFP 6.0 table. I have no problem moving numeric constants to SQL, but can't seem to get the syntax right to move the character data over. Below is my statement:

m.cStatement = "INSERT into Producercodes (iAgencyID, cAgencyLocation,) Values (1, ?m.AgLoc)"

m.AgLoc being the value in cAgencyLocation.

When I run =SQLEXEC(nconnhndl, m.cStatement) the iAgencyID field on the SQL server table is populated with 1, but cAgencyLocation remains blank.

Suggestions?

Marie