Export DB to a formatted text file

[Zilloux]

Hi,
I have a DB with different tables and I want to create a formatted text file. This file can contain comments or "KEY = Value" lines or "Value" lines.
All the values are stored in the DB.
What is the best way to do that, VB, Access itself, ASP or something else.

Any comment appreciated.
Thanks
ZIL

 

[JerryDennison]

One of the easiest and most controllable ways to export data is to use queries. Once you've "built" so that it orders and displays the data the way you want you need only right click it and Export/Save As...

 

[BoxHead]

If you want to do it with VB, take this form Help:

Syntax

DoCmd.OutputTo objecttype[, objectname][, outputformat][, outputfile][, autostart][, templatefile]

The following example outputs the Employees table in rich-text format (.rtf) to the Employee.rtf file and immediately opens the file in Microsoft Word for Windows:

DoCmd.OutputTo acOutputTable, "Employees", acFormatRTF, "Employee.rtf", True