Free Trial

Safari Books Online is a digital library providing on-demand subscription access to thousands of learning resources.

  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint

FILE PROCESSING

Do you know that you, too, can build your own database to store a collection of data? You can—and you can do it with file I/O (input/output) and a little help from this chapter.

Within VBA there are many techniques for building and managing file I/O routines. File I/O is the approach taken by programmers to manage data stored in files. Data files that you create can be viewed and edited through Microsoft text editors such as Notepad.

Most data files that you work with are built upon a common foundation, much like a database. The data files you learn about in this chapter share the following relationships and building blocks:

Data File. A collection of data that stores records and fields

Record. A row of related data that contains one or more fields, separated by a space, tab, or comma


  

You are currently reading a PREVIEW of this book.

                                                                                                                    

Get instant access to over $1 million worth of books and videos.

  

Start a Free Trial


  
  • Safari Books Online
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint