Neben dem eigenen ODB-Dateiformat, das wie alle OpenDocument-Formate auf XML beruht, unterstützt OpenOffice Base auch das. Most databases need a primary key, so you may want to check the Create primary key box. Die Anbindung an OpenOffice erfolgt über die Protokolle ODBC oder JDBC. In the Base window, click Tables to view the tables. If you copy a dBASE sheet, include the top row that contains the header data.

You can enter a range reference like A1:X500 in the Name Box if you don't want to scroll. You can open a *.dbf dBASE file or many other file types. Open the Calc file that contains the data to be imported to Base. Tables: OpenOffice tables can be created in design view by a wizard. Open a Base file of the database type that you want.Įither create a new Base file using the Database Wizard, or open any existing Base file that is not read-only. It is the default file format of OpenOffice Base.

sdb file contains databases (tables, forms, queries, reports) created and used in this program. If a field in the first valid data row contains a number, the whole column is set to number format, and only numbers, no text, will be shown in that column. File extension sdb is associated with OpenOffice Base, a fully featured desktop database management system, designed to meet the needs of a broad array of users. For example, to ensure the first column has a text format, you must make sure that the first field of the first valid data row contains text.

Openoffice base import data