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