Re: Excel Performance: How to import large data into existing worksheet.

Tech-Archive recommends: Speed Up your PC by fixing your registry

There used to be a bug in ADO, there was a big memory leak if you queried
an open workbook. We had to close the workbook, query it and reopen. looks
like your problem is a similar thing. Either a big memory leak or possibly
JET caching?
Have you tried the XML approach?
http://support.microsoft.com/kb/307021/EN-US/

Can you import, save, close and reopen, and repeat or is the performance too
poor?

let us know how you get on
cheers
Simon

<hot39827mail@xxxxxxxxxxx> wrote in message
news:1128606781.267029.139290@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
> For Office 2K3, the AutoSave is replaced by a new feature: AutoRecover,
> and it is disabled during import.
>


.

Quantcast