Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Client freezes while iterating through Excel
Message
From
19/12/2000 09:24:39
 
 
To
All
General information
Forum:
Delphi
Category:
OLE Automation
Title:
Client freezes while iterating through Excel
Miscellaneous
Thread ID:
00455005
Message ID:
00455005
Views:
66
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
Reply
Map
View

Click here to load this message in the networking platform