Learn More About...

You may find it helpful to review guidelines for preparing files for import and security considerations for data import. In addition, each type of data requires specific table formats.

Related Topics:

  • Data Import Security
    Vision closely controls who can use the Data Import utility.
  • Preparing Files for Import
    To be loaded into Vision, a file must be either a text file (with the extension .txt or .csv) or an ODBC DSN file (Access table or another SQL Server database).
  • Validating Data
    Before you import a table into Vision, Vision must validate its contents. During validation, Vision compares the project numbers, employee numbers, accounts, and other information in the table to the setup information previously entered into Vision.
  • Vision Table Names
    The Vision tables have corresponding import files.
  • Table Formats Overview
    When you use the Data Import utility, you must follow the prescribed formats for certain types of data.
Parent Topic: Data Import Utility