FrontBase Documentation

Backtrack:
  Welcome!
    4. Administering a FrontBase Server
      4.9. Backup and Restore
Updated: 20-Nov-2000
prev — next
Table of Contents

4.9.2. Importing from FrontBase Flat Files

FrontBase allows you to import content data from ASCII flat-files directly into a database. Use the following SQL statement:

INSERT INTO SCHEMA <schema-name> FROM 'FrontBase' INPUT('<path name of file with data>');

The format of the file must be as if generated by the export functionality of FrontBase.
A common issue for all import formats is that the schema must be properly defined before the import will work. The import filter is very unforgiving about incorrectly formatted input. Please experiment with a test database before working with a production database!

If you have feedback or questions on this document, please send e-mail to doc-feedback@frontbase.com. Please reference the section number and topic. Thanks!!