How to save records for Excel:

Once you have searched for your records, they will appear on your screen as comma-delimited text.

1. In Internet Explorer or Netscape go to FILE/SAVE AS.

2. In the SAVE AS window make sure TYPE (in Explorer) or FORMAT (in Netscape) is set to TEXT.

3. Choose a name for your file and give it an extension of .TXT.

4. Save your file. Your new text file can now be opened with MS Excel.


How to open your saved records in MS Excel:

1. Start MS Excel. Go to FILE/OPEN.

2. In the OPEN window, make sure "Files of Type" is set to "All Files." Open your text file.

3. The Text Import Wizard will now appear.

STEP ONE OF THREE
(screen shot goes here)
Choose "next".

STEP TWO OF THREE
(screen shot goes here)
Choose "comma"; make sure "" are selected.

STEP THREE OF THREE
(screen shot goes here)
Choose "finish".

4. Your data will appear in an Excel spreadsheet. Adjust your column widths and you're done!


Back to Search Page