InfoPath Dev

I need a secondary data source to populate a dropdown list for a form.  I want to create an xml file and populate it to include with my xsn.  I have all of the records in Excel 2007 that I want to use to populate the xml file, but cannot uncover how I can populate it with repeating records.

I manually created an xml file containing 1 record using XML Notepad.  I try to Map the element to the Excel spreadsheet that has all of the records, but only 1 record gets recorded when I Export to xml.

 Anyone have another suggestion?

I will answer my own post since I figured out how to do this.  I used XML Notepad to create a simple xml file with 1 temporary record.  I started Excel 2007 and from the toolbar selected Data/Get External Data/From Other Sources/From XML Data Import.

Once I had that opened, I copied all of the records from my other spreadsheet into this one, sorted it, and saved it as an xml file.  Now I can used this one as the secondary datasource and include it with my XSN file.