we are trying to import an excel 2007 spreadsheet into a sql database and then create an Infopath form using the database
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.
we imported Excel spreadsheet into a sql database named markbook.
this gave us columns of the spreadsheet we need to be able to select individual fields from within the columns
in Infopath we need to created rules for fields in which the values are equal to the individual database column cells