AX2437

Import Wizard: Source tab

The Source tab of the Import Wizard specifies the source of the data to be imported. The contents of the tab depend on the Import type selection at the top of the tab.

The available import types are as follows. Select the type that corresponds to the source of the data that you want to import:

Import Type Description More Information

File

Use to import data from a file:

  • Delimited files or Excel files
  • A single file or multiple files

Importing from one or more source files

External database

Use to import data from an external database. The following database connections are supported:

  • SQL Server
  • Oracle
  • OLEDB
  • ODBC

Importing from an external database

Internal database

Use to import data from one Axiom Software table to another, within the current system. The source data can be located within the system database or the audit database.

Importing from an internal Axiom Software database

Ellucian

Use to import data from an Ellucian system. This option only displays if it has been enabled for your system.

Importing from an Ellucian system

Intacct Use to import data from an Intacct system. This option only displays if you have licensed it.

Importing from an Intacct system

NOTE: The OLEDB source type can also be used to import data from a file. If you want to import from a file that is not one of Axiom Software's supported file types, you may be able to use the OLEDB source type. The database connection strings can be configured to pull data from various file types.

The topics in this section detail the requirements and import settings for each import type.