OpenOffice.org 2, Firefox, and Thunderbird for Windows All in One [Electronic resources] نسخه متنی

1.

Export Your Data

In Access, or wherever your data resides, export that data to an Excel spreadsheet or an OpenDocument spreadsheet (if this option is available). In Access, you can right-click over a table name, select the

Export option, select the Excel XLS spreadsheet format, and click

Export All to export the entire table.

2.

Load the Data

Select

File, Open and then select the file to load into Calc.

3.

Create a Data Range from the Data

Select all the data including the column headings. Once you've selected all the data that is to reside in the database, select

Data, Define Range to define the data as a data range and to name the data range. This name becomes your database name for this data.

TIP

If column headings didn't import from the original source, you should take the time to add them. The column names will serve as field names for your data.

Click

Add to save the data range and return to your spreadsheet. If you don't perform any database-related tasks, such as sorting or filtering, you can work with the data just as you would any spreadsheet data. The data, when defined in a data range, however, is also available to you for analysis as a database.