Primoz

How big is the file? Even if it's too large to transform with XSLT you maybe 
able to use an XmlReader if the format suits.

-- 

Joe Fawcett (MVP - XML)
http://joe.fawcett.name

"Primoz Bradac" <primoz.bradac@b...> wrote in message 
news:MPG.230ccc5676cc79b3989683@m......
>
> Thank you Joe for your answer. Yes, that was my idea too, especially
> because Access 2003 does not have such limitation. Unfortunately Access
> can't handle XML elements with attributes (that is the case with my .XML
> file), and I get empy tables. So I'd need a transformation of the .XML
> file anyway...
>
> Primoz
>
>
> In article <OPSUDpR$IHA.1180@T...>,
> joefawcett@n... says...
>>
>>
>> "Primoz Bradac" <primoz.bradac@b...> wrote in message
>> news:MPG.230c0b6beef361d0989686@m......
>> > Having been unable to get any answer in excel newsgroup I am trying in
>> > this one:

>> >
>> > I have to import an xml file into Excel 2003. When importing I get a
>> > message saying it's too big to import. When importing into Excel 2007
>> > (it succeeds!) I get more than 74000 rows which obviously can't fit 
>> > into
>> > Excel's 2003 65000 rows of one sheet.
>> >
>> > I have to stay with Excel 2003. Is there a way to import such an XML
>> > file into Excel 2003 as a pivot table (which somehow "compreses" the
>> > extent of rows).
>> >
>> > TIA
>> > Primoz
>> Well I would suggest transforming the XML first to get a more compact
>> representation. But that might not be easy, maybe what you want is just 
>> no
>> possible with such an old version of Excel.
>>
>>