Submit a request

Call Us: 1-888-339-3304

What types of Databases can be created from a Pointfile?

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.

 

Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request

Comments

Please sign in to leave a comment.

Powered by Zendesk