Database Import page

The Database Import page allows the user to import data from another dLabel database or from a non-dLabel data file - such as an older dLabel database, or an ASCII data file obtained from another word-processor, spreadsheet or database.

To import data from a file the file may be selected by pushing the Browse button and choosing the required file from the standard Windows Open dialog.

The separators used within the data 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 data sources.

Note that dLabel can import only ASCII files obtained from other programs; thus it can import ASCII files exported from Excel, Word or Access, but it cannot import the native XLS, DOC or MDB files of those packages.

Data imported from files may be appended to the end of any existing data currently within dLabel (by checking the Append Data checkbox before pushing the OK button) or may replace any existing data (by unchecking the Append data checkbox).

The data within some data files may have text fields contained within quotation marks. dLabel can be instructed to ignore the quotation marks by checking the Remove Quotes checkbox before pushing the OK button.

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

The data in the first record of an imported file may be used to automatically name fields of the dLabel database by checking the Rename fields checkbox. A database must exist before an import can be performed, and if it does not contain enough fields the import function will create and name more fields. If the existing database contains more fields than are required, the un-renamed fields will remain with their previous names.

The data file is imported when the OK button is pushed.

More:

Database Export page