How to copy data from one database table to another database table?
<p>I need help about my coding in vb.net copying data from one database table to another database table in ms access database.</p>

<p>Here are my codes:</p>

<pre><code>Dim conn2 As OleDbConnection
   Dim cmd2 As OleDbCommand
   Dim SQLStr2 As String


    conn2 = New OleDbConnection("Provider=Microsoft.ACE.OLEDB.12.0;Data Source= '" &amp; TextBox3.Text &amp; "' ;Jet OLEDB:Database Password=cscfo13poppsi; ")


   SQLStr2 = "SELECT * FROM pop IN '" &amp; TextBox3.Text &amp; "'"
   conn2.Open()
   cmd2 = New OleDbCommand(SQLStr2, conn2)
   cmd2.ExecuteNonQuery()

   Dim conn As OleDbConnection
   Dim cmd As OleDbCommand
   Dim SQLStr1 As String

   conn = New OleDbConnection("Provider=Microsoft.ACE.OLEDB.12.0;Data Source=psipop.accdb;Jet OLEDB:Database Password=cscfo13poppsi;")
   SQLStr1 = "INSERT INTO pop 'psipop'"
   conn.Open()
   cmd = New OleDbCommand(SQLStr1, conn)
   cmd.ExecuteNonQuery()
</code></pre>

<p>The error is "syntax error in INSERT INTO"</p>