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


VB Petition

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.

 


© 1998-2010, Dev Ashish & Arvin Meyer, All rights reserved. Optimized for Microsoft Internet Explorer