Question

Which file formats are used for importing and exporting data from OpenOffice Base?

in openoffice base, you can import data from a ____
a. spreadsheet
b.text file
c. database file

you can export data to a ____
a. spreadsheet
b. text file
c. database file

Answer 1

OpenOffice Base can import and export data from a variety of file formats, with option a, be and c: spreadsheets, text files, and database files.

So, to import:

• Spreadsheets: OpenDocument Spreadsheet (.ods), Microsoft Excel (.xls, .xlsx), CSV (.csv, .txt)
• Text files: Text encoded (.txt), HTML Document (.html, .htm), DocBook (.xml)
• Database files: MySQL (.myd, .myi, .sql), PostgreSQL (.pgsql), Oracle (.dbf)

Therefore, to Export:

• Spreadsheets: OpenDocument Spreadsheet (.ods), Microsoft Excel (.xls, .xlsx), CSV (.csv, .txt)
• Text files: Text encoded (.txt), HTML Document (.html, .htm), DocBook (.xml)
• Database files: MySQL (.myd, .myi, .sql), PostgreSQL (.pgsql), Oracle (.dbf)

Answer 2

Examples of The file formats used for importing and exporting data from open office are:

• Open Document formats (.ods and .ots )
• Impress
• star-writer formats ( .sdw,.sgl and .vor)

In open-office base you can import data from a Database file ( C )

you can export to a spreadsheet ( A )

Step-by-step explanation:

An open-office base is a fully designed desktop database management system. it is designed to serve a very large number of users especially in a firm. it can be used to track personal CD's and even used to produce monthly/yearly sales report for any department in the firm.

It is designed with JAVA as the programming language and it can run on most operating systems like: Linux windows and Mac