title: Getting data from one database table into another database table
body: <p>I imported data from MS-Access into a SQL database using the import/export wizard.
  Now, I have database called</p>
  
  <p>TestDatabase - With a Table called AccessTable - It has 10 columns.</p>
  
  <p>on the same SQL Server, I have another database called SampleDatabase with a table called
  SampleTable </p>
  
  <p>I want to copy [TESTDATABASE].[dbo].[AccessTable] to [SampleDatabase].[dbo].[SampleTable]</p>
  
  <p>The structure of this table is slightly different. The first two columns don't match but the rest of it match and I want to copy only those matched column.</p>
  
  <p>How to achieve this?</p>
  
  <p>In short: I want 1000 rows from first database insert into second database table.</p>
  
  <p>I am using SQL Server 2008 express for the time being.</p>