title: sql server load data without modifying the table structure
body: <p>I'm working on a project of migrating an Access database to SQL Server 2008. I have successfully recreated all objects as SQL Server objects, but because the original database was still in use, some data within changed.</p>
  
  <p>What's the easiest way to reload affected tables, without the table structure and relationships getting destroyed. I tried Import and Export data tool, included in the installation, but it complains about foreign keys whenever I ask it to wipe the data on the server. </p>