Importing is a simple matter of selecting a file data source, then matching fields from the import file to the destination file. When you first choose the Import menu option a browse style screen will be displayed. This may
be empty if you have not added any records until now, or there may be some records already displayed. Click the Import button to start the process.
The first step is to choose the type of data (Excel by default, but the drop down list will let you choose from a variety of data sources. Here I have changed to use an Access .mdb file. I then clicked the button with the ... to browse to the mdb file. In this case, there are many tables in my source file.
I click on the peripherals table to expand the list, then rather than picking individual fields, click the arrow while I have the Peripherals table selected to move all fields. I can pick and choose the fields next.
After clicking next, I can click the Arrow button with the + sign to let the program match all the fields it can. Since the field names don't all match, I manually "pair" the fields that were missed by selecting the field on the left, selecting the matching field on the right and click the Arrow button to add the field. If I make a mistake I can press the arrow pointing to the left to remove field. NOTE: I don't need to match an ID field since this will be created as an auto number field when the import process begins.
The next screens allow me to choose other options such as to filter the data to be imported or a sort option. This is usually not needed. Just click through the Next screens until you get to the Finish button. When you click finish the data should be imported and displayed in the browse screen. Note: this browse screen doe not have an update option, it is just to display the imported data. Close the screen and choose the browse computers menu option to work with the imported data.