title: Import Multiple Excel files to SQL Server
body: <p>I have about 40+ excel files that I would like to import to SQL Server 2012. The import wizard is a great tool but it only allows me to import one file at a time.</p>
  
  <p>I want to avoid using SSIS because the import should be relatively easy - basically it is just a direct copy-paste with the first row in the Excel files being the column names, and the Excel Files name = Table Name.</p>
  
  <p>Is there any easy way to achieve this?</p>
  
  <p>Edited: Since the columns will change quite frequently, I would like to avoid creating the tables manually. The wizard is great because it will create the table for me automatically.</p>