title: importing access 2003 database to sql server 2008
body: <p>I am importing an MS Access 2003 database to SQL Server 2008 through the SQL server import and export wizard. The database is imported successfully, but when I look at the tables on both sides, they are different. For example, some of the tables that are there in the access database are not present in SQL Server while some created in SQL Server are not present in the original database.</p>
  
  <p><img src="https://i.stack.imgur.com/J0LmY.png" alt="enter image description here"></p>
  
  <p>Some of the tables absent from the original database are highlighted
  <img src="https://i.stack.imgur.com/tZ59v.png" alt="enter image description here"></p>
  
  <p>Why is this happening? How can I verify the import then?</p>
  
  <p><strong>Important edit:</strong> It is importing the queries instead of tables. The entries seen in the wizard are present as queries in the original database.</p>