Thanks for your help Tom, now is there a way to loop thru the array and put the
values in , EXAMPLE something like:

INSERT INTO MERCHANT VALUES(FOR I TO LENARRAY;ARRAY(I)) OR
I HAVE TO WRITE EVERY SINGLE ONE

thanksss

happy holidays

>Mark,
>
>You can't 'insert from array' in to access because it's a native to foxpro not true SQL. You'll have to use INSERT INTO merchant (fld1, fld2, ...) VALUES(var1, var2, ...)
>
>-Tom
>
>>I am using the following code
>>
>>
>>gnConnHandle = conector handle
>>get data.. into array myarray
>>*- INSERTING DATA TO THE ACCESS TABLE
>>SEQSTRX = 'INSERT INTO merchant FROM ARRAY myarray'
>>=SQLPREPARE(gnConnHandle,SEQSTRX)
>>=SQLEXEC(gnConnHandle,SEQSTRX)
>>*- END
>>
>>and nothing happens, I do connect to the database
>>and create views with it and now I want to update it
>>any help in what I am doing wrong??
>>
>>mark