Message stating "too many data fields"

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Tgar99 - 24 Mar 2005 20:55 GMT

I am extracting numerous variables from an external database. However, I am
only using so many at a time depending on the form I'm using. When I merge, I
keep getting a message stating, for example "record 2 contained too many data
fields." It goes away after you clock "OK". But if you have 100 records you
have to click "OK" on all of them in order for it to merge. Is there anyway
too turn this message off permanently? Thank you.

Reply to this Message

Peter Jamieson - 24 Mar 2005 22:22 GMT

This doesn't have anything to do with the fact that you are not always using
all the fields in the data source. It is usually caused by a mismatch
between the number of fields listed in the header record of the data source
and the number of fields Word finds in the data records. That might happen
because there really is a variable number of fields in each record, or it
might happen if, for example, your data source is a comma-delimited text
file and commas are used in your data, e.g. if you have a street address
like 23, High Street and do not surround it with quotes. Or it may happen
because you have a plain text data source with unquoted multiline addresses.

Peter Jamieson

>I am extracting numerous variables from an external database. However, I am
> only using so many at a time depending on the form I'm using. When I
[quoted text clipped - 6 lines]
> anyway
> too turn this message off permanently? Thank you.

Reply to this Message