title: Prevent date converting in VBA
body: <p>I'm try to read data from en excel file to insert them in a table.
  I have a column with general formating, it can contains any thing. Testing the validaty is done by code. My problem is when i read an integer/double, 23 for exemple, it's converted to 1900-01-22 which is not logic in my case.
  The follwing is my code to connect and read from excel</p>
  
  <pre><code>Dim rsExcel As Object
  Set cnnExcel = CreateObject("ADODB.Connection")
  Set rsExcel = CreateObject("ADODB.RecordSet")
  With cnnExcel
      .Provider = "Microsoft.Jet.OLEDB.4.0"
      .ConnectionString = "Data Source=D:\Query1.xls;Extended Properties=Excel 8.0"
      .CursorLocation = 3
      .Open
  End With    
  rsExcel.Open "SELECT * FROM [Sheet 1$]", cnnExcel
  ' to read the column
  rsExcel.Fields(3).Value
  </code></pre>
  
  <p>Is there any way to prevent this automatic conversion</p>
  
  <p>Thank you for your help</p>