title: How to merge multiple access database with similar column field
body: <p>I have multiple MS Access (.mdb) databases which consist of exactly the same fields, a big database has been split into multiple parts to make it manageable.</p>
  
  <p>I have imported all of the .mdb files into MS SQL Server but I don't know how to merge them all into one big database, or if that's not possible, then how to make a query so that it will search from all the databases and return the result.</p>
  
  <p>Let me give an example to make myself more clear:</p>
  
  <p>I have <code>part1.mdb</code>, <code>part2.mdb</code>, <code>part3.mdb</code>, ..., <code>part50.mdb</code> files.</p>
  
  <p>All of the files contain the fields: </p>
  
  <ul>
  <li><code>name</code></li>
  <li><code>mobile no</code> </li>
  <li><code>address</code> </li>
  <li><code>city</code> </li>
  <li><code>state</code></li>
  </ul>
  
  <p>Now if I have to search certain <code>mobile no</code> then I have to search in all of the files which is very tedious.</p>