Data Output/Export Options
SAVE AS A SPREADSHEET FILE - Internet Explorer 6
1. Select Save as a Tab Delimited File from the Data Output/Export dropdown list.
2. Enter your search criteria into the form, e.g. Gold Creek
3. Click on Submit
- Results screen will be displayed as tab delimited text
4. In Internet Explorer click on View --> Source
- Displays results in Notepad
5. In Notepad, click on File --> Save As; enter file name followed by .xls (e.g., Gold.xls)
6. Select desired folder; click on [Save]
7. Open the file in Excel
- Displays Text Import Wizard
8. Ensure Delimited is the selected option then click on [Next]and then click on[Finish] to accept all the defaults
- Displays data in columns in Excel
9. In Excel, click on File --> Save As...
- Displays Save As Dialog Box
10. In Save as type, select Microsoft Excel Workbook
11. Click on [Save]
- Displays prompt to replace original file
12. Click on [Yes] to convert txt file to Excel
SAVE AS A SPREADSHEET FILE - Internet Explorer 5
1. Select Save as Tab Delimited File from the Data Output/Export dropdown list.
2. Enter your search criteria into the form, e.g. Gold River
3. Click on Submit
- Results screen will be displayed as tab delimited text
4. Select File, Save As and
(a) Under Save In select directory into which you wish to save the file;
(b) Under File Name change "CAA1UV01" (or whatever alpha-numerical ID is in that field) to the desired name and add a .xls extension, e.g. Gold.xls
(c) Set save as type to Text File (.txt)
5. Click on Save
- File is saved to your directory
6. Start up Microsoft Excel; open the file.
7. Upon opening the file, the Excel Text Import Wizard window will appear.
(a) Ensure that the "file type that best describes your data" is set to "Delimited." Click on [Next]
(b) Ensure that the "Delimiters" field is set to "TAB". Click on [Finish]
8. Re-save file as a Microsoft Excel Workbook (i.e. set "Save as type" to "Microsoft Excel Workbook (.xls)" then click on [Save])
SAVE AS MAILING LABELS FILE
Mailing labels can be created by saving the query results in Excel (as outlined above) then using the Mail Merge-Mailing Labels feature in Microsoft Word.
1. Select Create Mailing Labels from the Data Output/Export dropdown list
2. Enter your search criteria into the form, e.g. Cheakamus River
3. Click on Submit
4. Follow the instructions in "Save as Spreadsheet File" (depending on IE5.0 or IE6.0) to save file to Excel.
5. Open Microsoft Word
6. Follow the instructions in Microsoft Word for setting up Mailing Labels (see MS Word User Guide).
|
