How many fields in Word (Office 2003) can be exported to excel?

[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]

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.

 

[Graham Mayor]

An Excel spreadsheet can have 65,536 rows by 256 columns (1,048,576 rows by
16,384 columns in Excel 2007)
You cannot make the sheet have more columns that it will physically handle
I suppose you could import the 1000 fields in manageable chunks into several
sheets, but what you would do with it once there is anyone's guess.
I would imagine too that you are going to have to import directly into Excel
rather than via a comma delimited file to achieve this.
The basic principles are covered at
http://gregmaxey.mvps.org/Extract_Form_Data.htm

--
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP


<>>< ><<> ><<> <>>< ><<> <>>< <>><<>