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
"Primoz Bradac" wrote in message news:MPG.230c0b6beef361d0989686@msnews.microsoft.com... > 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. -- Joe Fawcett (MVP - XML) http://joe.fawcett.name
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@TK2MSFTNGP04.phx.gbl>, joefawcett@newsgroup.nospam says... > > > "Primoz Bradac" wrote in message > news:MPG.230c0b6beef361d0989686@msnews.microsoft.com... > > 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. > >
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" wrote in message news:MPG.230ccc5676cc79b3989683@msnews.microsoft.com... > > 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@TK2MSFTNGP04.phx.gbl>, > joefawcett@newsgroup.nospam says... >> >> >> "Primoz Bradac" wrote in message >> news:MPG.230c0b6beef361d0989686@msnews.microsoft.com... >> > 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. >> >>
