Query import data - bin location table, Query import data – bin location table – IntelliTrack Inventory Management User Manual
Page 337
Appendix F
Microsoft Access Integration
311
Click Yes.
Save the query as Import Sites.
Click OK.
14.
To verify the data is in the Site table:
Select the Site table in the navigation pane.
Open the table to view the imported data.
Query Import
Data – Bin
Location
Table
To transfer the imported location data into the bin location table, create a
select query based on the imported data and then update the bin location
table by running an append query.
1.
To run a query based on the imported location data click Create >
Other > Query Design.
2.
From the Show Table dialog box, select the table you created when
you imported the file initially. Click Add.
3.
Click Close to view the table’s fields. The table has it’s own window in
the header of the Query form.
4.
Drag the Site field to the first column of the Field row and the Bin
Location field to the second column of the Field row.
5.
Click the Design tab and select Results > Run.
6.
The query runs and the data in the bin location import file appears. Ver-
ify that this is the data that you want to import into the file.
7.
To update the Bin Location table with the new data, run an append
query. To run an append query, place the window in Design View by
selecting View > Design.
8.
Next, select Design tab > Append.
9.
An Append dialog appears; click the drop-down arrow in the Table
Name field and select the Bin Location table from the Table Name
list. Select the Current Database option. Click OK.
10.
Place the cursor in the Append To row in the Site field and select a Site
from the pull-down list.
11.
Place the cursor in the Append To row in the BINLOC field and select
BINLOC from the field’s drop-down list.
12.
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; you are prompted to save it. Save the query as Import
BINLOC. Click OK.
14.
To verify the data is in the Bin Location table:
2287.book Page 311 Thursday, July 7, 2011 4:45 PM