Specifications

106 Using Databases with ID Works Projects
ID Works Standard and Enterprise Version 5 Administrator’s Guide
This ensures that all data entered in a Production Form text field will
be saved in the database. Database text fields created for ID Works
photo, signature, or binary fields stored as files are set to 255
characters.
Importing Data from a Text File to an
Access Database
You can use a utility in the ID Works Administrator application to
create a Microsoft Access 2000 database that contains information
from your text file, to add records to an existing Access database, or
to replace the existing database records with information from your
text file. The Import Data from Text File command on the Tools
menu starts a four-step wizard that requests the information
necessary to complete the import operation. Online help is available
for each step by selecting the Help button on each page of the
wizard.
Information you will need includes:
• The name and location of the text file, the character that is used
as the field separator, the character (if any) that starts and ends
text fields, and whether the first row of the file contains field
names. Valid field separator characters are comma (,), tab,
semicolon (;), and space. Text field delimiter character choices
are double quote (“) and none.
• The name and location of the database to create or the existing
database to use and the names of the database table and
columns that are to be created or changed.
• The text file field you want to be the primary key field.
Alternatively, you can have an AutoNumber column created in
the database table. If you select to have an AutoNumber column
created, duplicate records in your text file will result in duplicate
database records. If you specify one of the text file fields to be
used as the primary key, any duplicate records will be identified
and the second occurrence will not be placed in the database.