Topic 46 - How to Import - Using the Import Screen |
|
From the main menu, click the Utilities button and then click Import Records. You will see an Import Screen, which has buttons that will help you import into each of the files in the database. * Click the button for each file you want to import into. * 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, you will usually want to change the "View By" box to "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 STW 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 right. 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. |