IntelliTrack Check In/Out - Manual (Page 501)

Appendix F
Microsoft Access Integration
471
This appendix specifies field order and criteria for tables in “Data Struc-
ture” on page 397 . Before importing data, review the data structures of the
five tables listed above in “Data Structure” on page 397 . If the import data
does not match the order and defined criteria, modify the export tables or
build a custom Access query to place the information in the appropriate
IntelliTrack table and fields.
Before importing the inventory data into a Check In-Out system, exit the
Check In-Out environment and enter the Access environment. Open the
Check In-Out system with the full version of Microsoft Access. Use the
Navigation Pane to reach the Access objects such as tables, queries, forms,
and reports.
Import Access Inventory Data
The first step in building the new Check In-Out system is to import the
existing inventory data. The existing inventory data is usually contained in
a single file, such as an Excel file. IntelliTrack’s Check In-Out database is
relational, and stores inventory information in several related tables.
1. From the External Data tab, select Import > and then select your
Import File Type from the ribbon options.
2. The Get External Data dialog appears. Click the Browse button at the
end of the File Name field.
2283.book Page 471 Thursday, July 7, 2011 2:29 PM