ADO: ActiveX Data Objects

Name

Stream Object — (Versions 2.5, 2.6)

Synopsis

Dim stream As ADODB.Stream

A Stream object represents a stream of data that is obtained from a URL, a Record object, or nothing at all.

Methods

Cancel

Cancels an asynchronous operation for the Stream object.

Close

Closes an opened Stream object.

CopyTo

Copies data from one stream to another.

Flush

Ensures that all changes made to a Stream object have been persisted to the resource that the Stream object represents.

LoadFromFile

Loads a file’s contents into an already open Stream object.

Open

Opens a Stream object from a URL, an opened Record object, or without a source at all, in memory.

Read

Reads a number of bytes from a binary stream.

ReadText

Reads a number of characters from a binary stream.

SaveToFile

Persists the data of a binary stream to a local file.

SetEOS

Changes the EOS within a given Stream object and to truncate any data that lies past the new EOS pointer.

SkipLine

Skips entire lines when reading text streams.

Write

Writes a number of bytes to a binary stream.

WriteText

Writes a number of bytes to a binary stream.

Properties

CharSet

Indicates the character set to which the contents of a text Stream should be translated.

EOS

Indicates that the stream pointer is currently at the end of the stream.

LineSeparator

Indicates the character (or characters) that are used to indicate the end of a line in text streams.

Mode

Indicates the permissions for modifying data within a Stream object.

Position

Indicates the position of the stream pointer within the Stream object. ...