problem opening large (5Mb) XML files in Excel...

O

Oleg

Hi, I have a problem opening XML files that are larger
than about 3Mb in Excel, it either crashes or gives "This
file caused a serious error".... while if I make the file
smaller(i.e. cut out some records) the same file opens
just fine. The file usually contains about 20000 records,
is there an upper limit to how many records Excel can open
with XML, because I know that a .dbf, or a comma-delimited
file with more than 20k records can be opened easily. Is
there an easy way to convert XML file to any other format
that could be opened?

Any suggestions/thoughts are most welcome...
Sincerely,
Oleg
 

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

Converting Large XML Files into CSV Files for Excel 0
Converting Large XML Files into CSV File via Excel 2
Problem opening Excel 97-2003 Worksheet in Excel 2007 0
Baffling problem with XML Reference in Excel Add-in 0
Setting xsi in Excel XML output... 0
problem in saving of excel files in excel 2007 2
Opening .xlsx files in separate instances of Excel 2007 0
Files open in older version of Excel 0

Top