Query import data - inventory by location table, Query import data – inventory by location table, Query import data – inventory by location – IntelliTrack Check In/Out User Manual
Page 419: Table 391, Query import data
Appendix C
Microsoft Access Integration
391
Query Import
Data –
Inventory by
Location
Table
To transfer the imported inventory by location data into the Inventory by
Location table, create an inventory by location table based on the imported
data and then update the inventory by location table by running an append
query.
1.
To run a query based on the imported inventory by location data, click
Create > Other > Query Design.
2.
A Show Table dialog appears. Select the table created when the file was
initially imported; click Add.
3.
Click Close to view the table’s fields. The table has its own window in
the header of the Query window. The Inventory by Location table
stores common product information. Only import the ItemNo fields.
Review the data structure of the Inventory by Location table to deter-
mine which fields to drag to the Field row.
4.
Click the Design tab and select Results > Run.
5.
The query runs and the data in the imported table appears. Verify that it
contains the imported data.
6.
To update the Inventory by Location table with the new data, run an
append query. To run an append query, place the window in Design
View.
7.
Place the cursor in the Append To row in the corresponding column of
the imported fields from the Inventory by Location table and select
ItemNo and any other corresponding fields from the Inventory by
Location table.
8.
Select Design > Append. An Append dialog appears; click the drop-
down arrow in the Table Name field and select the Inventory by
Location table. Select the Current Database option.
9.
A message appears notifying you that you are about to append the
table. To continue, click Yes. To cancel appending the data, click No.
10.
Close the query; you will be prompted to save it. Save the query as
ImportInventory. Click Yes.
11.
To verify the data is in the Inventory by Location table:
Click on the Table tab.
Select the Inventory by Location table.
Click Open to view the imported data.
2283.book Page 391 Thursday, July 9, 2009 11:26 AM