Importing a large .XML file into Excel 2003

P

Primoz Bradac

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Importing xml file to excel 2
Merging from an Excel file with graphics 1
Merge Excel file into Word Document 3
Help Creating XML File from Spreadsheet 1
XML Maps and worksheet protection problem 0
Importing XML Data in Access 2003 1
import external data as a List (not table) into excel 2010 with excel 2000-2003 list format 0
XML into Access 2003 3

Top