Database Export page

The Database Export page allows the user to export the either an entire database or the marked records of a database to an ASCII file suitable for use by another word-processor, spreadsheet or database.

To export data to a file the filename may be specified by pushing the Browse button and entering the required filename into the standard Windows Save dialog.

The separators to be used within the exported file to mark the end of lines, fields and records must be entered in the Separators boxes. A drop-down list fills in these boxes for a number of commonly encountered requirements.

User defined separators may consist of any valid ASCII characters or any of the following symbols used for non-printing characters:

\p       new paragraph
\r       carriage return
\n       line feed
\t       tab
\v       vertical tab
\f       form feed

Note that dLabel can export only ASCII files; thus it can export ASCII files which can be subsequently imported into Excel, Word or Access, but it cannot export the native XLS, DOC or MDB file formats of those packages.

The first record of an exported database can contain the field names used within dLabel if the “Export field names as first record” check box is checked.

 

More:

Database ADO/ODBC page