title: How can I insert each line from txt file into separate rows in a SQL Server database?
body: <p>I have a text file which has words from dictionary like..</p>
  
  <pre><code>ABACA
  ABACHI
  ABACHISTA
  ABACO
  ABADESSA
  ABADIA
  ABALIETA
  ABARICA
  </code></pre>
  
  <p>Now what I want to do is insert this list from a text file into a SQL Server table. I can not possibly add quotes manually. I think one way of doing this could be copy pasting this into Excel sheet and then importing it or adding quotes but Excel sheet has like 65k rows in a sheet and this text file has much greater number of words in it. So how can this be done easily? I am using SQL Server 2008.</p>