Xbase Documentation

Import Export

You can import and export tables, to files that can be used with other applications.

Import

Xbase can import Comma Separated (.csv), Tab Delimited (.tsv) and dBase (.dbf) files. To import a file into the currently open database, select Import... from the File menu. Choose the file you want to import and click Open. Enter a table name (remember table names can only contain letters, numbers, spaces, hyphens and underscores).

You must now name your columns. By default, Xbase names each column with the value of the first row in the document. To change a column name, double click it and type a new name. If you want to ignore a column, uncheck the checkbox beside its name.

Finally, click the Import button to start the import process. Importing may take several seconds for large files. When the file has been imported, Xbase opens the new table in data view.

Export

Xbase can export to Comma Separated (.csv), Tab Delimited (.tsv), SQL and HTML files. To export a table, select Export... from the File menu. Select the table you want to export, along with a file format. Click Next, then select a filename and location and click Save.

There are many different dialects of SQL. Xbase exports SQL compatible with MySQL, PostgreSQL, MS SQL Server and SQLite.