ADO Stream object: Read Method

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

ADO Stream object: Read Method

The Read method is used to read the entire stream or a specified number of bytes from a binary Stream object and returns the resulting data as a variant.

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

Syntax

var=objStream.Read numbytes

Example

Dim intNum as Integer, varStreamRead
intNum = 1234
' ...some code
varStreamRead = objStream.Read intNum

 
Parameter

Description

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

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

StreamReadEnum Values

Constant Value

Description

adReadAll -1 Default. Reads all bytes from the stream, from the current position to EOS.

Note: This is the only valid value with binary Stream objects