What Can You Import?

Vector HelpDesk uses Microsoft Access functionality to import data, so you can import from any of the formats and applications supported by Microsoft Access:

    Microsoft Access (databases other than the open database)

    Delimited text (values separated by commas, tabs, or other characters)

    Fixed-width text (values arranged so that each field has a defined width)

    Microsoft Excel (versions 2.x, 3.0, 4.0, and 5.0)

    Lotus 1-2-3 or 1-2-3/W (.WKS, .WK1, and .WK3 files)

    Paradox (version 3.x or 4.x .DB files)

    FoxPro (version 2.0 and 2.5 .DBF files)

    dBASE III and dBASE IV (.DBF files)

    Btrieve (with the data definition files FILE.DDF and FIELD.DDF)

    SQL databases, using ODBC drivers

    HTML

With Vector HelpDesk, you can import data into any of the fields in the tblDts table. This table contains most of the issue data.

You cannot use Vector HelpDesk to import data into the following tables:

    tblUser, which contains user information such as the user's logon name, full name, e-mail address, and telephone number.

    tblAttachment, which contains the names of the files attached to different issues.

    Any of the tables that contain the possible values for choice lists.

Related Topics

About Importing Issues

How New Records are Created

Before You Import

Importing Issues into a Source Table

Combining Multiple Source Tables

Importing Issues from Projects

Creating Queries to Merge Source Tables

Mapping Fields