Importing Issues into a Source Table

You don't import issues directly into the Vector HelpDesk tables. Instead, you import the issues into a source table. Vector HelpDesk copies the imported data into its tables after you define a mapping between the fields in the source table and the Vector HelpDesk fields.

To import issues from a file:

1    On the File menu, click Import Issues.

2    Click New Source Table to import data from a text file, spreadsheet, or database table into a Microsoft Access table (the source table).

3    In the Files of Type list, click the file format you want to import.

To import issues from another Vector HelpDesk database (or from any other Microsoft Access database), click Microsoft Access.

4    Click the file you want to import, and then click Import.

To import issues from a Vector HelpDesk Access database, select the project01.dat file.

5    In the Import Objects dialog, select the import options you want.

If you are importing from a text file or spreadsheet, select the First Row Contains Field Names check box.

If you are importing from a Microsoft Access database, select the tables you want to import.

6    Click OK to import the data.

Vector HelpDesk creates a source table named after the file you selected.

7    To import another file, repeat steps 4 and 5. When you've finished importing, click Close.

To import issues from a SQL database:

1    On the File menu, click Import Issues.

2    Click New Source Table.

3    In the Files of type list, click ODBC.

4    In the Select Data Source dialog, click the Machine Data Source tab.

5    Find the SQL Server data source and click OK.

6    In the SQL Server Login dialog, type your SQL Server login ID and password.

7    Click Options, and in the Database list, click a database.

To import issues from a SQL Server database, click the issue database.

8    Click OK.

9    In the Import Objects dialog, select that tables you want to import.

For SQL Server databases, the table to import is dbo.tblDts.

10   Click OK.

Related Topics

About Importing Issues

What Can You Import?

How New Records are Created

Before You Import

Combining Multiple Source Tables

Importing Issues from Projects

Creating Queries to Merge Source Tables

Mapping Fields