Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
VSTO Excel Rows to SQL Server 2005
I have a VSTO app (VS 2008) that allows users to combine data from 2
or more Excel 2007 worksheets in the active workbook. Currently I am sending the data back to SQL Server to do the heavy lifting. I'm looping over the rows and inserting each via a stored proc. Unfortunately with anything over a hundred or so rows it runs really slow and I am running into MDA messages (ContextSwitchDeadlock was detected). Is there a better/faster way to load this data into SQL Server? I like VSTO as opposed to VBA which I understand may be faster at this because it provides a nice add-in that users can add or remove. SSIS is not really an option for me because the data will in the sheets will be generated on the fly by the user based on an OLAP drillthrough - so I would prefer not to have to save the file. Any thoughts are appreciated. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
VSTO 2005 Excel Addin | Excel Programming | |||
VSTO 2005 - How to use ThisWorkbook as an Excel.Workbook | Excel Programming | |||
VSTO 2005 Excel picturebox control question | Excel Programming | |||
VSTO 2005 Excel picturebox question | Excel Programming | |||
reference vsto Excel ListObject in Vb.Net 2005 project/app | Excel Programming |