[Tess-Bristol]

I am preparing a Word (Office 2003) form for our project to use to capture
data.

I am using fields to store data. I plan to then export the data from the
form and into excel (In Word: Tools/options/save/save data only for forms)

My problem is that I have a lot of
fields and Excel will accept - at most 256 fields?
Can Excel be forced to accept more data? I have about 1000 fields.
Many of the data fields are empty as the form is capturing diverse
information.
Is there
a) a more elegant way?
b) is it described somewhere how to import more than 256 items of data into
word. (I am using .txt documents with the data delimited by commas).
Many thanks

[macropod[_2_]]

Hi Tess-Bristol,

See reply to your post on the same topic in microsoft.public.word.vba.general.

Please don't post the same question separately in different groups - post simultaeneously if appropriate.

--
Cheers
macropod
[Microsoft MVP - Word]


"Tess-Bristol" wrote in message ...
I am preparing a Word (Office 2003) form for our project to use to capture
data.

I am using fields to store data. I plan to then export the data from the
form and into excel (In Word: Tools/options/save/save data only for forms)

My problem is that I have a lot of
fields and Excel will accept - at most 256 fields?
Can Excel be forced to accept more data? I have about 1000 fields.
Many of the data fields are empty as the form is capturing diverse
information.
Is there
a) a more elegant way?
b) is it described somewhere how to import more than 256 items of data into
word. (I am using .txt documents with the data delimited by commas).
Many thanks