This is invalid syntax. Try following:
SQLEXEC(lnAccess,"INSERT INTO mytable (mytable.no,mytable.batch,mytable.filename) VALUES (" + alltrim(str(tmpdata.no)) + ", '" + tmpdata.batch + "', '" + tmpdata.filename + "')", "Mytable")
This statement assumes that tmpdata.no is numeric and tmpdata.batch and tmpdata.filename both are strings.
Plamen Ivanov
MCSD .NET Early Achiever and MCAD .NET Charter Member (VB .NET/SQL Server 2000)
MCSD (VB 6.0/SQL Server 2000)
VB (.NET) - what other language do you need in the whole Universe?...
