<div>
Dim TextLine<br />
Open &quot;TESTFILE&quot; For Input As #1 &nbsp; ' Open file.<br />
Do While Not EOF(1) &nbsp; ' Loop until end of file.<br />
&nbsp; &nbsp;Line Input #1, TextLine &nbsp; ' Read line into variable.<br />
&nbsp; &nbsp;Debug.Print TextLine &nbsp; ' Print to the Immediate window.<br />
Loop<br />
Close #1 &nbsp; ' Close file.<br />

</div>


Dim TextLine
Open "TESTFILE" For Input As #1   ' Open file.
Do While Not EOF(1)   ' Loop until end of file.
   Line Input #1, TextLine   ' Read line into variable.
   Debug.Print TextLine   ' Print to the Immediate window.
Loop
Close #1   ' Close file.


<div>
Thanks<br />
<br />
This is better as i need to deal with each one on its own<br />
<br />
SILKI
</div>


Thanks

This is better as i need to deal with each one on its own

SILKI

<div>
Make sure you dimension the variables appropriately, so instead of all variants:<br />
Dim Fld1, Fld2, Fld3<br />
<br />
They could be:<br />
Dim Fld1 As String, Fld2 As Integer, Fld3 As String<br />
<br />
Thanks for the points,<br />
Anthony
</div>


Make sure you dimension the variables appropriately, so instead of all variants:
Dim Fld1, Fld2, Fld3

They could be:
Dim Fld1 As String, Fld2 As Integer, Fld3 As String

Thanks for the points,
Anthony

<div>
<div class="content wysiwyg-content">
HI<br />
<br />
Can some please tell me the best way in vb to read froma text file <br />
<br />
I have one.csv<br />
<br />
silki,19,silki@mydomain.co<wbr />m<br />
james,34,james@mydomain.co<wbr />m<br />
SPJ,56,SPJ@mydomain.com<br />
<br />
So i wish to read in each line do sumthing with the data then move next ?????<br />
<br />
One question will this be reliable as my past ASP FSO experinec had been bad ????<br />
<br />
SILKI<br />
<br />

</div>
</div>


HI

Can some please tell me the best way in vb to read froma text file 

I have one.csv

silki,19,silki@mydomain.com
james,34,james@mydomain.com
SPJ,56,SPJ@mydomain.com

So i wish to read in each line do sumthing with the data then move next ?????

One question will this be reliable as my past ASP FSO experinec had been bad ????

SILKI



Read from a TEXT file ??

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.