The standard import option (with the access runtime) only supports importing item data via a delimited text file. The delimited files that are supported are: comma delimited, quote comma delimited, semicolon delimited, and tab delimited. The field order for the data in the delimited file is as follows: item (required), qty, description, unit cost, category, minimum qty, maximum qty, reorder qty, alternate item number. When importing the file, the IntelliTrack application assumes this field order. The only required field is the item number field. If you are importing data, but not importing all of the information as listed above, you must maintain file integrity by placing a separator in the fields that do not contain data. Chapter 11 in the manual shows import file type examples and covers import file type structure integrity in more detail. After you have imported item data, inventory can be created for it via the "add item to location" function available at the Item Data form in the application.
If you have a full version of Microsoft Access and you are familiar with importing data directly into Access tables, you can import any existing inventory data directly into the application database, without defining any of it manually, including site, location, and on-hand quantity. When using the full access import, to maintain data integrity, the tables must be imported in the following order: Sites, Bin Location, Inventory, TblCheck, Inventory by Location. More information on importing inventory data via a full access import is found in the manual: Appendix E, Microsoft Access Integration. Please note that we recommend this option only if you have experience importing data using MS Access tools.
