#### Excel

You can convert Microsoft Excel spreadsheets into databases that can be read by Seagate Crystal Reports through ODBC. In Excel 4.0 and earlier, use the Set Database command on the Data menu. In Excel 5.0 and later, use Define on the Name submenu of the Insert menu. Once converted, spreadsheet rows become records, and spreadsheet columns become fields. (For more information on converting your spreadsheets to database format, refer to your Excel documentation). Once the spreadsheet is converted, you can set up an ODBC data source for the file, and then select it from Seagate Crystal Reports.

Note:

- If you are using Excel 7 or later, you can export your spreadsheets as Access database tables, and read them from Seagate Crystal Reports as you would read any other Access tables. For more information, refer to your Excel documentation.
- You can also use the Microsoft Excel add-in to create reports in Seagate Crystal Reports.

In Windows 95, Windows 98, and Windows NT, you can set up an ODBC data source for Excel spreadsheets using the DAO engine. The DAO engine is installed on your system when you install Seagate Crystal Reports. However, you must set up an ODBC data source manually for your Excel spreadsheet. See Setting up an ODBC data source.

Seagate Software, Inc. http://www.seagatesoftware.com Please send comments to: techpubs@seagatesoftware.com