title: transfer data from Excel to SQL Server
body: <p>I have an Excel Spreadsheet that contains all my data that I need to put into an SQL Server database. I am fairly new o ASP.NET and have never had to export from Excel to SQL Server before.</p>
  
  <p>My Excel spreadsheets looks like this</p>
  
  <blockquote>
    <p>Trade Heading -> ArtID -> BusinessName -> AdStyleCode -> Address -> Suburb</p>
  </blockquote>
  
  <p>In SQL Server I have created a table named "Listings" which is in this format</p>
  
  <blockquote>
    <p>intListingID -> intCategoryID -> BusinessName - ArtID -> intAdCode ->Address -> Suburb</p>
  </blockquote>
  
  <p>What would be the best way to export the data from Excel and then import it into SQLServer 2005.</p>
  
  <p>Thanks...</p>