- Open the Data Source Explorer, right-click the table and select .
- Select External File as the Source Type.
- Click Launch.
- Click Browse and specify and Input File.
- Select the File Type from the drop-down menu.
- [Optional] Select the Column Labels in First Row check box to specify to use the first row of data as the column labels for the new table.
- [Optional] Check the Stop Loading if Max Error(s) Occur check box if you want to stop the load process if the number of errors you specify occur.
- [Optional] Select the Lock Table check box to lock the table during the load operation.
- [Optional] Select the Replace Existing Data check box if you want the existing data in the Aster table to be replaced by the loaded data.
- [Optional] Select the Include Null Row box if you want to include null rows in the table.
- [Optional] Select the Use System Locale box if you want to use the format displayed.
- If you selected Delimited Text as the file type:
Field Description/Action Column Delimiter Type of delimiter to be used. The options are: - Comma
- Semicolon
- Space
- Tab
- | (vertical bar)
Character String Delimiter Distinguishes a string text. The options are: - " (double-quotes)
- ' (single quote)
- None.
File Encoding Character set to use to encode the data. The options are: - UTF-8
- utf-16
- ISO-8859-1
- UTF-16BE
- UTF-16LE
- US-ASCB
- Cp1252.
- If you selected Excel (.xlsx) or Excel 97-2003 (.xls), select the Excel worksheet from which to load the data.
- Click Finish.