When you first launch the menu option to import peripheral inventory you will see a screen like the one below. This may be empty or may display some records you have already entered. To begin the import process click the Import button at the lower left of the screen.
You will first need to choose the data source type from a drop down list box. The default type is Microsoft Excel, but a variety of sources may be available on your computer. I have chosen to import using the Microsoft Access Drive, and I have clicked the button with the ... to locate the .mdb file on my computer. In this case, there are many tables to choose from displayed in a tree view on the left side column. I click on the Periph branch and expand the tree to select some fields.
It may be easier to select the branch level, in this case Periph, and click the arrow to move all columns to the right side. I can later match only the fields I want to import.
Here, I have clicked the button with the arrow and the + sign to attempt to match fields automatically. I then manually drag any missed fields from the left column to the right column. NOTE: I did not match any field to the ID field. Generally, you will not want to assign anything to ID type fields since they are automatically numbered.
On the next screen I could choose to filter data, but this is usually not needed so you would just click next to go to the next screen.
This screen shows the data found to be imported.
Finally, I click the Finish button to import my data. The browse screen should now show my imported data, but I can't edit the data from this screen. Just close the screen and use the other menu options to view and edit the imported data.
