Identifying records and fields in your data
Depending on the source of the data that you are importing, the process of identifying record and field specific data is different. To successfully import data, you must ensure that the characters used to separate records and the fields that are contained are identified.
About this task
The way that information is separated within the original data, must be specified so that the values can be correctly mapped to field types in iBase. Depending on your source, the steps to identify your data will differ.
To identify records in an OLE DB datasource, see Importing from OLE DB data sources.
To identify records in a Microsoft Excel spreadsheet, see Importing from Microsoft Excel worksheets.
To identify records in files in a directory, see Importing files from a folder.
Procedure
To identify records in text files:
In the File Name, specify the file path and name for the file that contains your data.
To determine where to start the import, specify the record to start the import from, and whether the first record is a list of the field names.
Select the characteristics of the text:
Option
Description
Text Qualifier
The Character to use to identify the start of the data to import.
Auto Trim Leading and Trailing Spaces in Data
Removes any spaces at the beginning and end of a field value.
Record Delimiter
The character that is used to split the data into separate records.
Field Delimiter
The character that is used to split the data in a record into different fields.
Dates, Times & Numbers
The formats used to store different numerical values within the data.