I was think mytable.no is numeric... Try this:
SQLEXEC(lnAccess,"INSERT INTO mytable (mytable.no,mytable.batch,mytable.filename) VALUES ('" + tmpdata.no + "', '" + tmpdata.batch + "', '" + tmpdata.filename + "')")
Also, you do not need third parameter in SQLEXEC - your statement do not return result.
Plamen Ivanov
MCSD .NET Early Achiever and MCAD .NET Charter Member (VB .NET/SQL Server 2000)
MCSD (VB 6.0/SQL Server 2000) br>
VB (.NET) - what other language do you need in the whole Universe?...