title: How to use SSMA (for Access to SQL Server) to migrate a table with different columns into a existing table?
body: <p>I am currently using Microsoft SSMA to migrate tables from my old Access database into an existing SQL Server. The two databases have exactly the same tables but one of the tables has an extra column. SSMA is returning an error for one of the table during migration complaining that the data type is not matching as the columns are actually aligning.</p>
  <p>For example, table in Access where <code>Col1</code> and <code>Col3</code> are both <code>datetime</code>:</p>
  <pre><code>ID Col1 Col3
  </code></pre>
  <p>Table in SQL Server: <code>Col2</code> is double and <code>Col1/Col3</code> are still datetime</p>
  <pre><code>ID Col1 Col2 Col3
  </code></pre>
  <p>Is there a way to get the tables to migrate Access data successfully into existing table (without overwriting the table)?</p>
  <p>P.S. I am using the command-line script to run SSMA</p>