Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Client freezes while iterating through Excel
Message
De
19/12/2000 09:24:39
 
 
À
Tous
Information générale
Forum:
Delphi
Catégorie:
OLE Automation
Titre:
Client freezes while iterating through Excel
Divers
Thread ID:
00455005
Message ID:
00455005
Vues:
67
I have an application which opens an Excel workbook and copies the contents to a database table. Invariably, as it increments through each row of the workbook, the app freezes at record 1110. All my other "Office" apps, that happen to be open at the same time stop responding as well. I've monitored memory usage during the process, but it does not appear out of the ordinary. I split the workbook into several sub-1000 record workbooks. The first workbook copies successfully, but any subsequent attempt to copy hangs the client, unless I reboot between attempts. I AM closing each instance of, but there seems to be some left-overs which I can't identify.

Anyone have any ideas why this might be happening?
Tim Butler
Répondre
Fil
Voir

Click here to load this message in the networking platform