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
-TomC