How to update the access database with the HTML table data

[susinthaa]

Hi All,

Good Morning!

My requirement is as below:

I am having a HTML table and the text boxes are embedded as a row of the tabel.

And I am having a button at the end of the page. When I click the submit button, the datas entered in the HTML table should be inserted into the access database.

I have created the access mdb in my local.

If I wrirte my input type code after closing the table, the database is updated with those values.
But the html table data is not updated in the access database.
I have attached my coding with this request.

please help me.

[gits]

@susinthaa
could you try to rephrase that ... so that it becomes a bit more clear what the problem is?

[RamananKalirajan]

Hi Susinthaa,
I have gone through your code I dont about the DB Connection stuff. But i noticed one thing.. In the Query statement you have directly used names.value. Its like you can access an input value directly like that. If you are having an input element means have an id for that element.

ex:
HTML Code

<input type="text" id="names" name="names" />  

In the JS you can access that element value using

document.getElementById('names').value

--> this will return the elements value. Just try and post back if you have any issues

Thanks and Regards
Ramanan Kalirajan