Specifications

98 Using Databases with ID Works Projects
ID Works Basic Version 5 Administrator’s Guide
Exporting Data from an Access Database
to a Text File
You can use a utility in the ID Works Administrator application to
create a text file that contains information from a Microsoft Access
2000 database. The Export Data to Text File command on the
Tools menu starts a four-step wizard that requests the information
necessary to complete the export 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 database, the table name if the
database contains more than one table, and the columns to
export.
• The name and location of the text file, the character to use to
separate fields, the character to use to delimit text fields, whether
to export column names as the first line of the file, and whether to
overwrite the file if it already exists. Valid field separator
characters are comma (,), tab, semicolon (;), and space. Text
field delimiter character choices are double quote (“) and none.