IntelliTrack Inventory Management - Manual (Page 336)

I NTELLI T RACK I NVENTORY V 8.1
User Manual
310
In the last window, name the table and click Finish.
If existing data is going to be stored in several files, import each of the
files and repeat the procedure for each file.
7. After the data is imported into the system, you must build and run sev-
eral queries to transfer the imported data into the following Inventory
tables:
• Site
• Bin Location
• Inventory
• Inventory by Location
Query Import
Data – Site
Table To transfer the imported site data into the Site table, create a select query
based on the imported data and then update the Site table by running an
append query.
1. To run a select query based on the imported site data, click Create >
Other > Query Design.
2. A Show Table window appears; select the sites table that you created
when you imported your site data and then click the Add button.
3. Click Close to view the table’s fields. The table has it’s own window in
the header of the Query window.
4. Drag the Site field to the cell in the first column of the Field row.
5. Click Design > Results > Run.
6. The query runs and the data in the query appears. Verify that the query
returned the records that you want to append.
7. To update the Sites table with the new data, run an append query. To
run an append query, place the window in Design View.
8. Select Design > Append.
9. An Append dialog appears; click the drop-down arrow in the Table
Name field and select Sites from the Table Name list. Select the Cur-
rent Database option. Click OK.
10. Place the cursor in the Append To row, in the first column of the
imported field.
11. Select the Site field from the Sites table.
12. Next, select Results > Run. A message appears notifying you that you
are about to append the table. To continue, click Yes. (To cancel
appending the data, click No.)
13. Close the query.
A dialog box opens prompting to save the design on Query 1.
2287.book Page 310 Thursday, July 7, 2011 4:45 PM