title: How to import and process Excel file in fastest way?
body: <p>We want to import and process the Excel data into SQL using ASP.Net</p>
  
  <p>For now we identified OLEDB is the best approach to read the excel file as most of our data are in Tabular format.</p>
  
  <p>Next to save this data into SQL, we have to process it to convert all the raw data to equivalent IDs. for example i have a below table </p>
  
  <pre><code>Country State       Sales 
  USA     Illinios    43435 
  USA     Wisconsin   3435 
  India   Karnataka   3434 
  India   Kerala      34345
  </code></pre>
  
  <p>Should be saved as</p>
  
  <pre><code>CountryID  StateID  Sales 
  22         122      43435 
  22         123      3435 
  26         201      3434 
  26         202      34345
  </code></pre>
  
  <p>Please suggest the best and fastest way to do this</p>