Data are exported from EA iXPRESS by category. Each category is exported to a separate database table. If a category contains multiple columns, each column is exported to a separate table.
Databases can be exported in the following formats:
- Microsoft Access - a single database is created, containing tables for each exported category or category column.
- Microsoft Excel - a single workbook is created, containing worksheets for each exported category or category column.
- dBase or CSV (text with comma separated values) - a folder is created, containing files for each exported category or category column.
Format | Advantages | Disadvantages |
Microsoft Access | Descriptive Variable names. Multiple output tables stored in a single database. |
Limited to 64 category tables or less, depending on content. Multiple categories significantly reduce performance. |
Microsoft Excel | Descriptive Variable names. Multiple output tables stored in a single workbook. |
Limited to 64 category tables or less, depending on content. Limited to 65,536 target records. Multiple categories significantly reduce performance. |
dBase | Fastest export, even with multiple categories. Unlimited number of category tables. Output tables stored as separate dBase files. |
Cryptic variable names, limited to 10 characters due to dBase format. |
CSV (text with comma separated values) | Descriptive Variable names. Output tables stored as separate CSV tables. CSV files can easily be imported to many applications. |
Limited to 64 category tables or less, depending on content. Multiple categories significantly reduce performance. |