I am encountering a problem when I want to create about 660 entries for a list box. Indeed I followed the instructions reported the topic " Using drop-down lists and list boxes" but the result expected does not happen.
When I copy and Paste, either everything goes into the caption box or only the first entry is taken and not the 659 others, which is, you will understand annoying. (Version 188.8.131.5229.1.523496)
The only other way I know of is to edit the xml directly. Add a list box or drop down list to your form. Select the field, then click the XML Source tab (next to master pages tab. If it's not there, right click to the right of the preview tab in the gray area and check off XML Source).
Where it says <items save="1" /> you can manually add in items in the following format:
you can paste all of your list items into column A in an excel sheet, then put the following formula into B1 and fill down for the length of your entire list:
copy all of column B for a list like:
you can then directly paste that into the xml.
User beware, editing the XMl incorreclty can destroy your form. Always backup before you fiddle with xml.
Edit: It may be easier to add one item to the list before opening the xml source. This will add the:
<text>your manually added value</text>
to the xml, allowing you to overwrite the "<text>your manually added value</text>" with your list from excel.