Data Source (File) Creation

[EGS3]

I'd like to create a data source with 1,000+ fields.

I'd like the format to be:

Field0001
Field0002
Field0003
..
..
..
Field1000
John
Q
Public
..
..
..
Red
Jane
A
Public
..
..
..
Red

Anyone have a link to instructions on how to create a data
file using this format?

TIA

Ed

 

[Peter Jamieson]

I think you can get close to this, but Word needs to have a record delimiter
that is different from its field delimiter. So you could use

Field0001
Field0002
Field0003
..
..
..
Field1000
<tab>John
Q
Public
..
..
..
Red
<tab>Jane
A
Public
..
..
..
Red
<tab>

where <tab> is just a tab character, and each line is ended with a paragraph
mark (if it is a Word document) or a carriage return/line fedd (i.e. a
normal line end in Notepad) if it is a .txt file. You will probably see an
additional field name called AutoMergeField when you list the fields in
Word.

Word will ask what the delimiter characters are when you attach the data
source but you should not see any further dialog boxes.

I've seen some reports that Word XP .txt data files with lots of fields do
not work properly as merge data sources, in which case you will probably get
better results by putting the data, using the same layout, in a Word .doc.
With Word 2003 here this seems to work with 1000 fields.