Importing Fixed Width Files with Multiple Occurrences

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

Hello, can someone please tell me how to set up flat file connection object
when the format of the file is as follows:

Date Record(s) - Fixed Format Assumed Decimal

Starting
Field Name Occurs Position Length Dec.
Format
---------- ------ -------- ------
---- ------

FIELD1 1 1 4
0 ccyy

FIELD2 1 5 8
- DATE

FIELD3 1 13 36
- TEXT

FIELD4 265 49 8
0 ccyymmdd



I believe set the delimeter to "Fixed Width", and then manually set each
field length based on the above specification. However, Is there an easier
way to set up Field4 rather than manually creating 265 fields with a length
of 8 characters in the connection object UI?

I can't seem to find an easy way of setting up this flat file connection
object.

Thanks for your help!

Jason

.