inserting rows from textbox to table

Hi,
I have been trying to insert textbox value to table.
Here is my code
x = Text1.Text
y = Text2.Text
MyConn.Execute ("INSERT INTO PUBLISHERS(Name,CompanyName) values ('&x','&y')")

If i use this code,the datas r not inserting from textbox,instead '&x' is added as one row in the table. :rolleyes:
Can Anyone help me out..


vbado

Dim sSQL as string

sSQL = "INSERT INTO PUBLISHERS([Name], CompanyName) VALUES('" & x & "', '" & y & "')"

myConn.execute sSQL

myConn.close
Set myConn = Nothing

Thanks a lot.
Now it works fine for me.

No problem, always glad to help.