Export records to an HTML file to extract information from the Datastream 7i database without making an external connection, e.g., from outside of Datastream 7i, to the database. The HTML file can be viewed using Microsoft Excel or any program that opens HTML files.
Follow these steps to export records from Datastream 7i.
Open the form from which to export records.
Query for the records to export.
|
Datastream 7i will export the results of the last query performed, even if you are not currently viewing those records (e.g., if you cleared the form). |
Click . Datastream 7i displays the Export to Excel dialog box.
|
To remove a field from the list of fields to be exported, select the field and then click on the forms toolbar |
Click Export. Datastream 7i displays a message indicating the number of records that will be exported and asking whether you want to continue.
Click Yes. Datastream 7i opens a new browser window and displays the exported records in a table.
Click Convert. Datastream 7i displays the records in Microsoft Excel or displays the File Download dialog box.
Save the file as necessary.
Refer to the following topics for information on exporting records from Datastream 7i.
Saving Filters for Exporting Records from Datastream 7i
Retrieving Saved Filters for Exporting Records from Datastream 7i
Deleting Saved Filters for Exporting Records from Datastream 7i