|
Overview
The General Tab is where the Data Table is chosen (available tables are displayed in the drop down), as well as the File Type (Delimited, Excel XLS, Access MDB, or ODBC Datasource) that will be imported.
Field Descriptions
| • | File Type - Data Source that is being used for the import. there are 4 options: |
| o | Excel (xls & xlsx) - VBScript |
| o | Access (MBD & AccDB) - Access SQL |
| o | ODBC - Contingent upon the driver. (ex. MS SQL = T-SQL, Oracle = Oracle SQL) |
| • | Use Column Headers - Use with Delimited & Excel Data Sources. When selected, the header row of the source data will be brought in as a record. |
| • | Delimiter - Use with Delimited Data Source. When using the Delimited import, this represents the delimiter that is used on the source data to separate the records for import. |
| • | Import File - Used with Delimited, Excel and Access Data Sources. The location of the file to be imported. |
| • | Table - Used with Excel & Access Data Sources. The name of the table that is being used as the source data. |
| • | Data Source - Used with ODBC Data Source. Source of the data. |
| • | User - Username to access the Data Source. |
| • | Password - Password to access the Data Source. |
|