Class Stream (ADODB VBA)

The class Stream represents a stream of binary data or text.

Methods

Cancel - Cancels execution of a pending, asynchronous method call.

Close - Closes an open object and any dependent objects.

CopyTo - Copies the specified number of characters or bytes (depending on Type) in the Stream to another Stream object.

Flush - Forces the contents of the Stream remaining in the ADO buffer to the underlying object with which the Stream is associated.

LoadFromFile - Loads the contents of an existing file into a Stream.

Open - Opens a Stream object to manipulate streams of binary or text data.

Read - Reads a specified number of bytes from a binary Stream stream.

ReadText - Reads specified number of characters from a text Stream object.

SaveToFile - Saves the binary contents of a Stream to a file.

SetEOS - Sets the position that is the end of the stream.

SkipLine - Skips one entire line when reading a text stream.

Write - Writes binary data to a Stream object.

WriteText - Writes a specified text string to a Stream object.

Properties

Charset indicates the character set into which the contents of a text Stream should be translated for storage in the Stream objects internal buffer.

EOS indicates whether the current position is at the end of the stream.

LineSeparator indicates the binary character to be used as the line separator in text Stream objects.

Mode indicates the available permissions for modifying data in a Connection, Record, or Stream object.

Position indicates the current position within a Stream object.

Size indicates the maximum size, in bytes or characters, of a Parameter object.

State indicates for all applicable objects whether the state of the object is open or closed.

Type indicates the operational type or data type of a Parameter, Field, or Property object.