title: How can I import an Excel file into SQL Server?
body: <p>I have data in an Excel file - actually <a href="https://en.wikipedia.org/wiki/Microsoft_Excel#Current_file_extensions" rel="noreferrer">XLSX</a> format since it is now 2020. My requirement is to get this data into SQL Server as follows:</p>
  <ol>
  <li><p>ad hoc, the use case being feeding tables with test data, or infrequent data loads of small amounts of data (say &lt; 3k rows), and</p>
  </li>
  <li><p>In a repeatable, robust, and possibly automated way for a production system.</p>
  </li>
  </ol>