Showing form data only for large form

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Steve Finlayson - 05 Jan 2004 17:53 GMT

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

Reply to this Message

Cindy M -WordMVP- - 05 Jan 2004 19:47 GMT

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 :-)

Reply to this Message