tags:

views:

100

answers:

0
Q: 

Running ODC file ...

Hi,

I have created an ODC file with connection to SQL server. I am running an Stored Procedure in the command text of the connection file. The Procedure has 2 parameters which is hard coded in the command text. The problem is, Every time i have to run the ODC with new set of parameters, i need to change it in the file's commandText. Is there anyway to invoke the ODC to execute the procedure taking in the parameters from excel.

Please somebody help me on this if i make some sense.

related questions

Setting a cell's format using Excel 2007 Interop and C#
Where should I post my python code?
excel: charting with unknown number of data
Read specific Coloumns from Excel files with C#
add decimal as time
How to display .net automation add-in functions in excel's formula autocomplete
Excel formula to refrence 'CELL TO THE LEFT'
Problems Reading a .xlsx file?
VBA code for SUMIFS?
Accessing Excel 2007 Binary (.xlsb) via OleDb ACE
How can I permanently prevent Excel from setting all new documents to R1C1 mode?
How do get the index of a table's column by using a structured reference in excel?
Can I make a structured reference absolute in excel 07?
Excel countif Pulling apart a cell to do different things
Upgrade from Excel 2003 to 2007 results in "stack overflow error" on previously working vba
System.Windows.Forms.ToolStrip height or autosize
VSTO problem - cannot create visual studio excel workbook project
Round function in Excel, worksheet function vs VBA
Reliable real values generator for Excel for Office 2007 and Vista SP1
Create an Excel workbook on a x64 system
How to import data from Excel 2007 xlsx file into SQL Server 2000 Database?
How do I send an alert to a blackberry from an Excel 2007 spreadsheet?
How to convert a column number (eg. 127) into an excel column (eg. AA)
How do I create an Excel chart that pulls data from multiple sheets?
VSTO Excel 2007 PivotTable, having a PivotField in more than one column