Hai;

I am having a problem, I want to insert data in ACCESS database via using SQL insert into

I want to add data in specific fields....
and I am Suffering...

Please help me , how I can update data
I am using the statement like

conn.Execute ("Insert into Class_Nursery (ID) values ('" & Student_ID & "')")

which is showing some error....

here "Student_ID" is variable and "ID" is the field Name;

If ID is a numeric field then...

conn.Execute "Insert into Class_Nursery (ID) values (" & Student_ID & ")"

Good Luck