Hi Ger,

Assuming that lnAccess is a valid connection, I think you're missing a parentheses. Try the following:

SQLEXEC( lnAccess,"INSERT INTO mytable (mytable.no, mytable.batch, mytable.filename) VALUES (?tmpdata.no, ?tmpdata.batch, ?tmpdata.filename)", "Mytable" )

and see if that doesn't work better. Also, I don't think you need the last "Mytable" argument unless you're dealing with sending -output- to a VFP cursor (you're inserting, not querying).

HTH.

You wrote:
>I have the following code for inserting a record into
>an access table, but nothing happens.
>
>SQLEXEC(lnAccess,"INSERT INTO mytable mytable.no,mytable.batch,mytable.filename) VALUES (?tmpdata.no,?tmpdata.batch,?tmpdata.filename)", "Mytable")
>
>Anyone any ideas?