title: SQL Server Management Studio 2012 - Export/Import data from/to table
body: <p>I have table with more than 3 000 000 rows. I have try to export the data from it manually and with SQL Server Management Studio <code>Export data</code> functionality to Excel but I have met several problems:</p>
  
  <ul>
  <li><p>when create .txt file manually copying and pasting the data (this is several times, because if you copy all rows from the SQL Server Management Studio it throws out of memory error) I am not able to open it with any text editor and to copy the rows;</p></li>
  <li><p>the <code>Export data</code> to Excel do not work, because Excel do not support so many rows</p></li>
  </ul>
  
  <p>Finally, with the <code>Export data</code> functionality I have created a <code>.sql</code> file, but it is 1.5 GB, and I am not able to open it in SQL Server Management Studio again. </p>
  
  <p>Is there a way to import it with the <code>Import data</code> functionality, or other more clever way to make a backup of the information of my table and then to import it again if I need it?</p>
  
  <p>Thanks in advance.</p>