Re: Creating and populating an XML file

rarroyo29 — Wed, 27 May 2009 14:43:53 GMT

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.

Creating and populating an XML file

rarroyo29 — Mon, 18 May 2009 19:12:20 GMT

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?

Data Connections

Re: Creating and populating an XML file

Creating and populating an XML file