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?