Member Avatar for kashy!

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;

  • 2 Contributors
  • 1 Reply
  • 101 Views
  • 7 Hours Discussion Span
  • Latest Post Latest Post by vb5prgrmr
Member Avatar for vb5prgrmr

If ID is a numeric field then...

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

Good Luck

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.