2
Reply

Error Executing an Insert Statement

Sea Sharp

Sea Sharp

Jul 18 2007 6:18 PM
1.8k
Hello everyone!

I have a small app which inserts records into ms access from c# 2.0.I build an ad hoc insert query based on the user input & use a command object to execute the same.The query has 40 columns.
The insert query works perfectly when executed in access DB.But the executeNonQuery method gives an error like "Syntax Error in Insert Into statement".I am stuck with this thing & new to access.Any help would be of great help.

Thanks

Answers (2)