This smacks of either a problem with your db handle or the query itself. Ensure you can connect as the user you're using from the machine that's running the script (with Access I'd assume it's local, but I don't like making assumptions like that) and can do an insert on that table. Also ensure you're not missing data for columns that have no default and are set not_null.
Comment on Re: Perl, Excel and MS Access Database (SQL-42000)
Thanks for your reply.
I have another script that does insert data on this same database, but never to this table called Level. Yes its a local database.
I checked everything you said at least 10 times. I really don't know why its happening.
Oh, I found it. "Level" is a SQL reserved word.
Thank you again!