Excel - XSD Mapping

[Cobby1812]

Hi there,

I have a XSD Schema
I have a sql view that isa called in excel via Microsoft Query and the data set returned into Excel.

I now want to map the schema to the file. Have bombed along until I have reached this point.

There is a part of the schema called Section, section then has Line Number and AnswerAlpha. The excel file has 4 sections, each section having anythjing from 9 to 1 Lines in them.......The mapping wont allow me to map this section to the multiple columns.......how on earth do I map this over. Excel comes up with an error saying List of Lists.....

I have copied the link for screen shots....please help...I am going a bit mad.

 

[tsuji]

You get a better chance for ui and excel question there:

http://www.tek-tips.com/threadminder.cfm?pid=68