Table of contents
Collapse the table of content
Expand the table of content

Writing Data to Files

office 365 dev account|Last Updated: 6/12/2017
1 Contributor

When working with large amounts of data, it is often convenient to write data to or read data from a file. The Open statement lets you create and access files directly. Open provides three types of file access:

  • Sequential access ( Input, Output, and Append modes) is used for writing text files, such as error logs and reports.

  • Random access ( Random mode) is used to read and write data to a file without closing it. Random access files keep data in records, which makes it easy to locate information quickly.

  • Binary access ( Binary mode) is used to read or write to any byte position in a file, such as storing or displaying a bitmap image.

    Note The Open statement should not be used to open an application's own file types. For example, don't use Open to open a Word document, a Microsoft Excel spreadsheet, or a Microsoft Access database. Doing so will cause loss of file integrity and file corruption.

The following table shows the statements typically used when writing data to and reading data from files.

Access TypeWriting DataReading Data
SequentialPrint #, Write #Input #
© 2018 Microsoft