View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
detritus detritus is offline
external usenet poster
 
Posts: 2
Default XML Import too slow

Dear All,

I've a XML file (12.000 records , around 6MB) and it's schema (around 15
columns). I added XSD file as a map and mapped all columns from A1. When I
import the XML file, it takes around 5 minutes to complete on P4 2.6GHz 768MB
RAM notebook.

As this is not bad enough, in our template design we need to export from one
sheet to import on another, I don't need to tell you how long these two
operation takes.

Is there any thing I can do to make this faster?

Thanks in advance.