title: How to import MS Access data into SQL Server using vb.net
body: <p>I have an old MS Access 2003 file that contains information about the personnel on a particular agency. The number of records in that database will range from 800 to 1500. </p>
  
  <p>I want to import those records into my SQL Server database. Is it possible that the importing of data can be done programatically using Visual Basic.net? </p>
  
  <p>If possible, please lend me some help. Thank you.</p>
  
  <p>Here is the structure of the table that I want all the data to be imported</p>
  
  <pre><code>     ID
       Fname
       Mname
       Lname
       Address
       Status
  </code></pre>