title: How to read values from Excel using Openrowset Function?
body: <p>I am reading excel sheet using openrowset function? </p>
  
  <p>My Excel sheet has numeric value in General Type Column. For some reason these values are brought over as nulls even though they have a values.  I am not sure why this is happening.  I looked into the format of the fields and they are set to General in Excel, I tried setting them to Text and that did not help.</p>
  
  <p>I tried to bring the contents from the excel source to a text file in csv format and for some reason the Text field containing numeric value came out as blank (NULL).</p>
  
  <p>Any inputs on getting this addressed will be much appreciated.</p>
  
  <pre><code>SET @Cmd = 'INSERT INTO Table_01
                  SELECT * FROM OPENROWSET(''Microsoft.Jet.OLEDB.4.0'', ''Excel 8.0;Database=' + @ExcelFilePath + ''',
                  ''SELECT * FROM [Sheet1$]'')'
      EXEC(@Cmd)
  </code></pre>