ADO

Hi ,

Can anyone give me the codes to open
"MyDatabase.mdb" and open new table "MyTable" to add data to that table

Thanks

public MyConn as ADODB.Connection
set MyConn = new ADODB.Connection

MyConn.Provider = "Microsoft.Jet.OLEDB.3.51"
MyConn.Open "C:\test.mdb", "", ""

Dim adors as ADODB.Recordset
set adors = new ADODB.Recordset
adors.Open "select * from TestTable", MyConn

adors.addnew



'Your Code goes Here
'your insert statement according to ur columns in your table, your table shd atleast contain one primary key


adors.update




The Ultimate Solution Providers

Authors

Sriman & Jayaraman

Email : [email protected]
[email protected]

Hand Phone : +(6) 016 2237147 (Malaysia)

Sorry "Askus",
I picked the wrong item from the rating combo
My vote = "6"

Jan