title: How to read recordset as string in VBA
body: <p>I have some code to read records from a database. when i read , the recordset variable modifies the table value to its own format.
  For Eg: </p>
  
  <p>In Database </p>
  
  <blockquote>
    <p>Time value is 12345 (Not date &amp; time) but when record set reads it, it
    comes as   For Eg: 23-06-2012
    10:15:23</p>
  </blockquote>
  
  <p>I just found that the recordset itself stores values in its own format after doing.</p>
  
  <p><code>Set rs = CmdSqlData.Execute()</code></p>
  
  <p>So is there any way to define a recordset as <code>String</code>?</p>
  
  <p>Here is the code.</p>
  
  <pre><code>Dim rs As ADODB.RecordSet
  Set rs = CmdSqlData.Execute()
  Do While (rs.EOF = FALSE And rs.BOF = FALSE)
    p = rs.GetRows(1)
    cell(1,1) = p(0,0)
  Loop
  </code></pre>
  
  <p>Can anyone please let me know how to read the data as String (as it is in database) so that no change in format will occur.</p>
  
  <p>Note: I can not convert Excel cell format due to other requirements but I want to read everthing as String From Table</p>