Altova Mailing List Archives>Archive Index >microsoft.public.xml Archive Home >Recent entries >Thread Prev - Importing large XML file into Excel 2003 >Thread Next - Re: Importing large XML file into Excel 2003 Re: Importing large XML file into Excel 2003To: NULL Date: 8/13/2008 8:58:00 AM "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. -- Joe Fawcett (MVP - XML) http://joe.fawcett.name | ||||||
| Company | Legal | Press | Partners | Careers | Sitemap | Contact Us | Altova Blog | Mobile | Full Site | |||
|
