Skip to main content

Writing data to files

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.

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

Access type Writing data Reading data
Sequential Print #, Write # Input #
Random Put Get
Binary Put Get

Leave a comment

Your email address will not be published. Required fields are marked *

Format your code: <pre><code class="language-vba">place your code here</code></pre>