best method to choose to save huge data from excel to Sql
<p>I have an Excel file from which I have to extract the required data and save it to a database. I know by using <code>Range</code> we can get a particular range of data. But my data that was to be extracted was a bit large. So can anyone suggest which was the best and simple method to retrieve the data and store the information in a database?</p>

<p>I would like to read the data from <code>A10</code> to an unknown range. My data will be as follows </p>

<p><img src="http://i.stack.imgur.com/FLleS.jpg" alt="enter image description here"></p>

<p>As per marked with red after that data should go in to the database <code>column</code> by <code>column</code> I will do that if anyone can suggest the best method to read the remaining columns too.</p>
