"John" <John@nospam.infovis.co.uk> wrote in message
news:OJRpaUvvEHA.1404@TK2MSFTNGP11.phx.gbl...
> Hi
>
> I am executing a query as below;
>
> Dim insStr As String = "INSERT INTO MyTable1 ( field1, field2, ...) ) " &
> _
> "SELECT MyTable.f1, MyTable.f2, " & _
> "FROM MyTable "
> Dim insCmd As New OleDbCommand(insStr, Conn)
> insCmd.ExecuteNonQuery()
>
> Is there a way to get the number of records actually inserted by this
> query?
>
> Thanks
>
> Regards
>
>