problem with INSERT INTO command

[d.paulson]

My guess is that emp_id is an interger or a long integer, so the string delimiter should be removed.

sql = "INSERT INTO DayWiseRoster (id) select UserOFTheMonth (id) where emp_id= " & clng(txtempid.text)