title: Inserting data from an Excel Spreadsheet into Microsoft Access using C# not working for specific fields
body: <p>Currently importing data from Excel into a MS Access database using a C# client, which works perfectly the majority of the time.</p>
  
  <p>Having specific instances wheres it doesn't work with no error being thrown. For the life of me i cant understand why.</p>
  
  <p>My SQL Statement:-</p>
  
  <pre><code>INSERT INTO [MS Access;DATABASE=C:\\TempReport.mdb].[Bucket]
  (ID,[RefName],[0M],[3M],[6M],[1Y],[2Y],[3Y],[4Y],[5Y],[7Y],[10Y],[12Y],[15Y],[20Y],[25Y],[30Y],[40Y],[40Y+]) 
  SELECT
  7,[RefName],[0M],[3M],[6M],[1Y],[2Y],[3Y],[4Y],[5Y],[7Y],[10Y],[12Y],[15Y],[20Y],[25Y],[30Y],[40Y],[40Y+])  FROM [MainReport$C29:AA48]
  </code></pre>
  
  <p>ConnectionString:-
  "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=[FILE];Extended Properties='Excel 8.0;HDR=Yes;IMEX=0;'";</p>
  
  <p>Problem:-
  Columns 20Y,25Y,30Y,40Y, [40Y+] never populate even if theres data, with no error being thrown.</p>
  
  <p>Please Help!</p>