Modules: Text Export Class

Home | French | About | Search | mvps.org


	What's New Table Of Contents Credits Netiquette 10 Commandments Bugs Tables Queries Forms Reports Modules APIs Strings Date/Time General Downloads Resources Search Feedback mvps.org In Memoriam Terms of Use

Modules: Text Export Class

Author(s)

Dimitri Furman

This VB/VBA class exports data from a Jet database in text delimited format. It provides some extra functionality compared to the TransferText method in Access.

As the data source, it can accept any one of the following: DAO recordset, table, tabledef, query, querydef, SQL statement, and a two-dimensional array. Any string can be used as field and record delimiter. Optionally, you can specify a string that will replace fields and record delimiters embedded in the data being exported. The class supports appending to existing files, exclusion of specified source fields from export, and some other features. Can be used in VB 5 and 6, MS Office 97, 2000, XP. See comments in code for sample usage and additional details.

The class has been updated since it was originally posted on The Access Web in 2000. Compared to the previous versions, it includes some minor enhancements and bug fixes. The syntax in this version is compatible with the previous versions of the class.

Download

© 2000 - 2002, Dimitri Furman. All Rights Reserved.

TextExport.zip

Contact Information:

Please contact Dimitri Furman for any additional questions.