ADO Stream Object: ReadText Method

Home | About me | EXCEL VB Programming (XL97-2003) | ACCESS Programming | EXCEL VB.Net Programming | EXCEL Spreadsheet Functions Material Management  |  Guestbook
 

ADO Stream object: ReadText Method

The ReadText method is used to read the entire stream, a line, or a specified number of characters from a text Stream object and returns the resulting data as a string.

Note: This method is only used with text Stream objects, for binary Stream objects, use the Read method.

Syntax

str=objStream.ReadText numchars

Example

Code:
Dim strStreamText
strStreamText = objStream.ReadText adReadAll 
Code:
Dim intNumChars As Integer, strStreamText
intNumChars = 1234

'.... some code

strStreamText = objStream.ReadText intNumChars 

 
Parameter

Description

numchars Optional. The number of characters to read from the file, or a StreamReadEnum value. Default is adReadAll

If you have specified more than the number of characters left in the Stream, only the character remaining are returned

 

StreamReadEnum Values

Constant Value

Description

adReadAll -1 Default. Reads all characters from the stream, from the current position to EOS
adReadLine -2 Reads the next line from the stream