title: Reading Excel sheet using ACE.OLEDB.12.0 with IMEX=1 not working
body: <p>I'm using the below Connection String with ACE.OLEDB.12.0 to read data from an XLSX Spreadsheet, but the I set IMEX=1, it does not work while when I remove IMEX=1 completely, it works fine.</p>
  
  <pre><code>"Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\Working Folder\ICDE\Ramsden 4.xlsx;Extended Properties=""Excel 12.0 xml;HDR=No;IMEX=1;"""
  </code></pre>
  
  <p>Can anyone explain why?
  Because I had the impression that IMEX=1 reads all data as text, so it was more secure!</p>
  
  <p>Thanks</p>
  
  <p>JP</p>
  
  <p>IMEX= &lt;0/1/2>
  IMEX refers to IMport EXport mode. This can take three possible values.</p>
  
  <p>IMEX=0 and IMEX=2 will result in ImportMixedTypes being ignored and the default value of ‘Majority Types’ is used. In this case, it will take the first 8 rows and then the data type for each column will be decided.</p>
  
  <p>IMEX=1 is the only way to set the value of ImportMixedTypes as Text. Here, everything will be treated as text.</p>