77. Import Data into a Calc DatabaseBEFORE YOU BEGIN 75 About Calc Databases 76 Create a Calc Database SEE ALSO 78 Sort Calc Database Data 77. Import Data into a Calc Database Although you can type data into a Calc database, if you already have that data stored elsewhere, you can usually import that data directly into Calc by first saving the data in a format that Calc can read. For example, suppose your company uses an Access database for its records and you want to import the customer table into Calc's database so that you can work with the data more easily. You would first export that customer table's data in Excel's XLS spreadsheet format and then open that spreadsheet in Calc. Once the table is open, you must define the data range and save the file as a Calc spreadsheet. See 73 Import and Export Sheet Data for help with importing non-Calc spreadsheets into Calc and 76 Create a Calc Database for help with converting your imported data to a Calc spreadsheet data range. NOTE A spreadsheet can have multiple data ranges, and they can overlap. Depending on how you want to sort or filter your data (see 79 Filter Data That You Want to See ), you might overlap several columns , or fields, in several different range names .
|