Showing form data only for large form

[Steve Finlayson]

I have a form that contains over 400 fields, many individual fields
and then several tables with lots of fields in them. I would like to
be able to save the data to a database or an Excel sheet but think I
might have a problem since the data exceeds the number of columns in
Excel. How can I handle this type of problem?

Thanks for any suggestions.
Steve

 

[Cindy M -WordMVP-]

Hi Steve,

I have a form that contains over 400 fields, many individual fields
and then several tables with lots of fields in them. I would like to
be able to save the data to a database or an Excel sheet but think I
might have a problem since the data exceeds the number of columns in
Excel. How can I handle this type of problem?

Well, if you were starting right out in Excel, how would you handle the
problem (400 fields vs. 256 columns, max)?

Word doesn't provide a way to automatically save a form (form fields?)
to a database or to Excel. It can save to delimited text format. Or you
can use VBA to transfer the data. I rather expect, given the number of
fields vs. the max. column limit in Excel (and Access, for that matter)
that you will probably need to use VBA for the data transfer.

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Sep 30 2003)
http://www.mvps.org/word

This reply is posted in the Newsgroup; please post any follow question
or reply in the newsgroup and not by e-mail