Access Database Homepage

Question: How can i insert data into access database.mdb using vb 2008?

(Posted by: The Phantom on 2010-07-09 08:09:24)

I've made a textbox and a button and i added a data source which is an access 2003 database it has the table name: first grade, column: names, and i want to add the text in the text box into the names column....PLzzzzz HELP!!!!

Posted by: SoccaFreak on 2010-07-09, 08:17:34

Dim sql_insert, param_User Dim data_source param_User = "the name you're putting into the database " data_source = "Provider= Microsoft.Jet.OLEDB.4.0; Data Source= " & "the location of the database, eg. c:\User\My Documents\database.mdb) sql_insert = "INSERT INTO first grade (names) VALUES (' " & param_User & "'); " Set con = Server.CreateObject( "ADODB.Connection ") con.Open data_source con.Execute sql_insert con.Close Set con = Nothing This is what I used for one of my websites, this is through an asp but since i used vb script for it, almost everything should be applicable for VB 2008.