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.
> 
>