Quote:
|
Originally Posted by Buff
He wants to connect the web form that he is writing to a database and have the data inserted into the database. Excel is not a database, it is a spreadsheet. He wants to code the form, and then the user presses select and it goes into the database. He doesn't want to do all the work that you are suggesting, everytime the page is visited.
He wants, when the submit button is pressed, to have a connection to the db opened, the results inserted into the fields of the database, the connection closed, and perhaps a message on the screen telling him/the user that the submission was successfull.
|
Bingo bango. I just need to look in the database and figure out which form field input goes into which table column in the database and write the SQL statement.
Say I have a field called fldName, how would I make that go into tblCustomers/CustomerName?