Run AccessAppend Query

[Yahya]

Dear Sires,

How can I run an append query in access from vb.net?

Regards,
Yahya

[Paul Clement]

Re: Run AccessAppend Query

On Tue, 9 Aug 2005 16:52:36 +0300, "Yahya" <x@x.x> wrote:

¤ Dear Sires,
¤
¤ How can I run an append query in access from vb.net?
¤

Not sure if you're referring to a QueryDef or SQL statement. The following executes a QueryDef:

Dim AccessConn As System.Data.Ole Db.OleDbConnect ion
Dim AccessCommand As System.Data.Ole Db.OleDbCommand

AccessConn = New System.Data.Ole Db.OleDbConnect ion("Provider=M icrosoft.Jet.OL EDB.4.0;" & _
"Data Source=e:\My Documents\db1.m db")

AccessConn.Open ()

AccessCommand = New System.Data.Ole Db.OleDbCommand ("QueryDefName" , AccessConn)
AccessCommand.C ommandType = CommandType.Sto redProcedure
AccessCommand.P arameters.Add(" @ParamName", System.Data.Ole Db.OleDbType.Va rWChar).Value =
"SomeValue"

AccessCommand.E xecuteNonQuery( )

AccessConn.Clos e()


Paul
~~~~
Microsoft MVP (Visual Basic)