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
Importing Issues into a Source Table
Combining Multiple Source Tables
Importing Issues from Projects