https://www.infopathdev.com:443/forums/39.aspxNew to InfoPath? Search to see if your question has already been answered. If it has not, then ask it here or the appropriate topic forum.enCommunityServer 2007 SP3 (Build: 31118.962)https://www.infopathdev.com:443/forums/thread/75069.aspxTue, 07 Feb 2012 21:53:29 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:75069Test1230https://www.infopathdev.com:443/forums/thread/75069.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=39&PostID=75069<p>Hello Ken,</p> <p>you can import the spread sheet to a sharepoint list and create the columns view, and from infopath form you can create a data connection to the sharepoint list.</p> <p>Then create a dropdown field control in infopath form, go to properties and lookup values from data connection, it will auto populate those 100 values in drop down list.</p>https://www.infopathdev.com:443/forums/thread/75063.aspxTue, 07 Feb 2012 20:54:29 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:75063Ken Branham0https://www.infopathdev.com:443/forums/thread/75063.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=39&PostID=75063<p>I&#39;m brand new to InfoPath and trying to create a form and need a little assistance.&nbsp; I have&nbsp;a drop down list of about 100 different options that could periodically change.&nbsp; I currently have this list stored in an Excel spread sheet.&nbsp; Is there a way I can embed the spread sheet into the form rather than having to key each one of the options into the drop down menu?&nbsp; Thank you for any assistance provided.</p>