https://www.infopathdev.com:443/forums/41.aspxIf you're not sure where to ask your question, ask it here. If necessary, our moderators will make sure it gets classified in the correct board.enCommunityServer 2007 SP3 (Build: 31118.962)https://www.infopathdev.com:443/forums/thread/41712.aspxThu, 14 May 2009 13:33:22 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:41712imiddleton250https://www.infopathdev.com:443/forums/thread/41712.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=41&PostID=41712<p>we are trying to import an excel 2007 spreadsheet into a sql database and then create an Infopath form using the database</p> <p>we are trying to make an infpath form that will give us names in a dropdown (we can do this bit) the having selected the name we would like it to poppulate other text boxes with the correct data.</p> <p>&nbsp;</p> <p>we imported Excel spreadsheet into a sql database named markbook.</p> <p>this gave us columns of the spreadsheet we need to be able to select individual fields from within the columns </p> <p>in Infopath we need to created rules for fields in which the values are equal to the individual database column&nbsp;cells</p>