Access 2003 VBA Programmer's Reference

D.10. The Stream Object

The Stream object in ADO represents a stream of binary data or text.

D.10.1. Properties of the Stream Object

The following table lists the various properties of the Stream object.

Property	Data Type	Description
Charset	String	Specifies the character set for the stream
EOS	Boolean	True if the current position is at the end of stream (EOS)
LineSeparator	LineSeparatorEnum	Specifies the character or combination of characters used as the line separator in the stream
Mode	ConnectModeEnum	Specifies the permissions for modifying data in the Stream object
Position	Long	The current position in the stream
Size	Long	Specifies the current size of the stream of data
State	ObjectStateEnum	Specifies the current state of the Stream object
Type	StreamTypeEnum	Specifies the type of data stored in the Stream object

D.10.2. Methods of the Stream Object

The methods you can use with the Stream object can be found in the following table.

Method	Description
Cancel	Cancels a pending asynchronous call to a Stream object
Close	Closes an open Stream object
CopyTo	Copies data from the Stream object to another Stream object
Flush	Flushes the contents stored in the stream's buffer
LoadFromFile	Loads the contents of a file into the Stream object
Open	Opens the Stream object
Read	Reads binary data from the stream
ReadText	Reads text data from the stream
SaveToFile	Writes data from the Stream object to a file
SetEOS	Sets the current position as the end of the Stream object
SkipLine	Moves to the beginning of the next line of data in the ...