Target Platform Limitations

The maximum number of output fields in TextConverter is defined by the type of the destination data storage. The file formats such as Excel, Access and DBF have a limitation of 255 fields per table and most of the databases over 1000. In TextConverter, if the output table was not set, it limits the number of output fields to 255.

 

The table below shows the exact numbers for the most popular formats.

 

#

Output Format

Type

Max number of output fields per table

1.

SQL Server

RDBMS

1064 (Non-wide tables), 30,000 (wide tables)

2.

Oracle

RDBMS

1,000 (v.8 and higher), 254 (v.7)

3.

MySQL

RDBMS

4096

4.

CSV

File

2032

5.

Excel

File

16,384 (v.2007 or higher), 255 (v.2003)

6.

MS Access

File

255

7.

DBF

File

255

Comments