I'm trying to export around 12,000 records from the DataGridView to Excel in vb.net. I let it run for about 16 minutes and noticed that the EXCEL.exe file is a running process chewing up about 40% - 60% of the processor. I clicked on the Export button control again and then get an error when doing so. Here's the following error:
I get the error COMException was unhandled. The RPC Server is unavailable. (Exception from HRESULT: 0x800706BA).
I wouldn't expect the return of the data to take that long and I've run my application several times with the same results.
Your help is much appreciated,
Sincerely
Wallace Davis