Working with Text Files

For purposes of working with text files in VBA code, there are three types of text files: comma-delimited, fixed-width (columnar), or free-form. Data from the first two types of text files can be imported or exported using the TransferText method in Access, and comma-delimited files can be processed with the TransferSpreadsheet method. If you just need to read data from (or write data to) a text file, but not import into a table, you can work with text files using the FileSystemObject, the legacy VB methods, or ADO.

p rj f- -rj, i^ng Exporting to (and importing from) comma-delimited and fixed-width text files is covered --- -J in Chapter 10.

0 0

Post a comment