title: Inserting more than 1000 rows from Excel into SQLServer
body: <p>I'm new to Sql but what is the best way to insert more than 1000 rows from an excel document into my database(Sql server 2008.)</p>
  
  <p>For example I'm using the below query:</p>
  
  <pre><code>   INSERT INTO mytable(companyid, category, sub, catalogueref)
     VALUES
     ('10197', 'cat', 'sub', '123'),
     ('10197', 'cat2', 'sub2', '124')
  </code></pre>
  
  <p>This is working fine but there is a limit of inserting 1000 records and I have 19000 records and I don't really want to do 19 separate insert statements and another question, is that the company id is always the same is there a better way then writing it 19000 times?</p>