<div>
I struggled with the same problem for awhile - its due to the differing ways different microsoft produts handle dates/time<br />
You dont need to convert the string at all - you just need to put in the sql statement correctly:<br />
<br />
strsql = &quot;INSERT INTO &lt;table&gt; (&lt;name of field to contain the time&gt;) VALUES ( #&quot; &amp;&nbsp;&lt;variable containing time string&gt; &amp;&nbsp;&quot;#)<br />
<br />
Hope it helps<br />

</div>


I struggled with the same problem for awhile - its due to the differing ways different microsoft produts handle dates/time
You dont need to convert the string at all - you just need to put in the sql statement correctly:

strsql = "INSERT INTO <table> (<name of field to contain the time>) VALUES ( #" & <variable containing time string> & "#)

Hope it helps


<div>
<div class="content wysiwyg-content">
hi all,<br />
<br />
currently i have a string, for example: &quot;20:18:54&quot; , is it a way to convert it into time format/type, so that i can use/insert it into a database where the field is time format. how to write it in vb code? thanks!<br />
<br />
<br />
mandy
</div>
</div>


hi all,

currently i have a string, for example: "20:18:54" , is it a way to convert it into time format/type, so that i can use/insert it into a database where the field is time format. how to write it in vb code? thanks!


mandy

urgent: vb, convert a string to time format

Visual Basic is Microsoft’s event-driven programming language and integrated development environment (IDE) for its Component Object Model (COM) programming model. It is relatively easy to learn and use because of its graphical development features and BASIC heritage. It has been replaced with VB.NET, and is very similar to VBA (Visual Basic for Applications), the programming language for the Microsoft Office product line.