Hi,

I am trying to use the ExportDescriptor object to navigate through a recordset and export each record's TEXT field data into its own .txt file, named by the Bates number (e.g., ABC001.txt, ABC004.txt). It works partially, by creating properly named .txt files, but each one has the same content -- the entire recordset's TEXT data. So it essentially gives me a .dmp file in multiple instances. How do I tell it to only write to each file that particular record's TEXT value? Thank you!

You cannot use the Export method to achieve what you wish to do.

You can make use of the FileSystemObject to create each file and write the text into it.

Norma

Thank you, Norma. Using the FileSystemObject worked beautifully to dynamically write the contents of each record's TEXT field to file. Appreciate the tip!

- Max