title: Access data insertion into SQL Server
body: <p>I'm stuck inserting data from an Access table into SQL Server 2008.</p>
  
  <p>I am doing following using C#:</p>
  
  <ol>
  <li><p>Connect to Access database using <code>OleDbConnection</code> </p></li>
  <li><p>Execute this statement using <code>OleDbCommand</code>:</p>
  
  <pre><code>Insert Into Table1
  In Server=localhost;Database=TEST;Integrated Security=SSPI
  Select * From Tables1
  </code></pre></li>
  </ol>
  
  <p>I'm getting the error </p>
  
  <blockquote>
    <p>Syntax error in Insert Command</p>
  </blockquote>
  
  <p>What do I need to do? Please guide.</p>