inserting row in ms acess table

[regalla]

hai
please any body can give me code how to insert one row in already prepared table in ms access

[P.manidas]

hai
please any body can give me code how to insert one row in already prepared table in ms access

Hi regalla_c,

Try these SQL codes. Hope these codes will help you.

'declaration
Option Explicit
Dim DB As Database
Dim S As String

Private Sub Form_Load()
Set DB = OpenDatabase(App.Path + "\Gbusiness.mdb")
End Sub

Private Sub CmdAdd_Click()
'Adding new record
S = "Insert into TeamAddress (slno, Name, Address) values("
S = S + "'" + Text1.Text + "'" + ","
S = S + "'" + Text2.Text + "'" + ","
S = S + "'" + Text3.Text + "'" + ")"
DB.Execute (S)
End Sub

[kinwang2009]

Hi,
I don't think P.manidas' code will Add New row to already created Table however it may add records to database.

Thankx

[debasisdas]

try this if using ADODB for database connection.

conn.begintrans            'ADODB connection object.
conn.execute "your insert statement goes here"
conn.committrans

[jhai_salvador]

Use ADODB.Connection
Use ADODB.Recordset

rc.AddNew 'Where rc ADODB RecordSet