Back to Table of Contents * Go to Topic 46

Topic 45 - How to Import - Using the menu command "File, Import Records"

To import data into any file ...

  • Open the file you wish to import INTO ... such as the Employer or STW file.
  • On the menu bar, click File, Import Records.
  • When you see the Open File dialog box, specify the drive and/or folder and filename of the file you want to import FROM. For example: F:\MassSTW2008\Employer.SKL or C:\MassSTW2008_Q1\Employer.skl.
  • Click Open.
  • When the Import Field Mapping Screen appears, make sure that the "View By" box specifies "Matching Names" so that each field will import into the proper field. In almost all cases, you'll want ADD NEW RECORDS to be selected at the bottom of this screen.
  • Click Import
  • The next dialog box checks to see if you want auto-entry options ON or OFF. When you are importing from one Mass. School to Career Database file to another, you want OFF (unchecked). But if you are importing data from another database or spreadsheet, you want to have the auto-entry options on in order to generate record IDs, creation dates, or other automatically generated fields.
  • Click OK.

After you import the data, just the newly imported records will be in the found set. Use the book to scroll through to see that they look correct. If yes, click Records, Show All Records. Or, if you realize that you've made a mistake, you can click Records, Delete Found Records to delete the currently found set.