AERROR(aa) should give you the information about what was wrong.

if sqlexec(...) <=0 
  if aerror(aa)>0
         ?aa[2]
  else
       ?"?????????"   
  endif
endif

>I can read in the access data into my cursor but the indsert does not work;
>
>

>
>=sqlexec(gnConnHandle,"INSERT INTO CLAIMS1 (CLAIMNO, CLAIMANT, RESPONDENT, CARRIER,STATUTE,STATUS,STATDATE,BOXNO,DOI,WCCNO,ANALYST,CLAIM_ID,CLAIMNT_ID,RESPOND_ID,CARRIER_ID,BOX_ID,STATUTE_ID) VALUES (X1,X2,X3,X4,X5,X6,X7,X8,X9,X10,X11,X12,X13,X14,X15,X16,X17)")
>
>
>

>
>the var x1 trough x17 contain valid data
>
>what am I doing wrong??
>
>Peter