INSERT INTO Visual Studio 2010 -

i newbie visual studio 2010, there may silly syntax error in code. so, please not downvote question. have database correct , name of table contacts. want insert table (columns - first name , last name) values. now, going wrong in code. error being shown {"syntax error in insert statement."} . please check out code. given below.

 dim conn new oledb.oledbconnection("provider=microsoft.ace.oledb.12.0;data      source=c:\users\rajesh\desktop\documents\visual studio 2010\projects\project   \contacts.accdb")      conn.open()      dim cmd new oledb.oledbcommand()     cmd.connection = conn     cmd.commandtext = "insert contacts (first name, last name)       values('bruce','lee')"     cmd.executenonquery()      conn.close() 

any of course appreciated.

i think need square brackets around column names because contain spaces:

insert contacts ([first name], [last name]) values('bruce','lee')