Import excel worksheet into existing access database table

See more:

VB

VB10

MS-Excel

MS-Access

    Public Sub ImportExcelToAccess()

        Dim AccessConn As New System.Data.OleDb.OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;" & _
        "Data Source=c:\db1.mdb")

        AccessConn.Open()

        'New table
Dim AccessCommand As New System.Data.OleDb.OleDbCommand("SELECT * INTO [tblSheet1] FROM
[Excel 8.0;DATABASE=c:\Book1.xls;HDR=NO;IMEX=1].[Sheet1$]", AccessConn)

        AccessCommand.ExecuteNonQuery()
        AccessConn.Close()


    End Sub

What I have tried:

I am trying to import an Excel worksheet into an existing Access database table using vb.net/ado.net. The "select" statement works fine
for creating a new table, but I cannot get the correct syntax for an "INSERT" statement that will populate an existing
table.