How to execute a parameterized Sql store procedure within Excel?

  • Thread starter Thread starter Paul
  • Start date Start date
P

Paul

How to execute a parameterized Sql store procedure within Excel and pass the
Excel cell value as the parameter(s). Need to look at sample to understand
the concept, if any. Many thanks.
 
hi, Paul !
How to execute a parameterized Sql store procedure within Excel and pass the Excel cell value as the parameter(s).
Need to look at sample to understand the concept, if any. Many thanks.
Click to expand...

see if any of the following is what you want...

Ed Ferrero: Run SQL Server stored procedure in Excel macro -> http://tinyurl.com/pdmg2
Robin Hammond: Stored procedures -> http://tinyurl.com/lpak2
{+} Getting stored procedure result to excel -> http://tinyurl.com/epors
Sean Connolly: pass paramter to SQL server stored procedure -> http://tinyurl.com/rdavt
several conversations -> http://tinyurl.com/op4k5
another conversation > http://tinyurl.com/3yyjtr

hth,
hector.
 
Paul said:
How to execute a parameterized Sql store procedure within Excel and pass the
Excel cell value as the parameter(s). Need to look at sample to understand
the concept, if any. Many thanks.
Click to expand...

An easy option is use this free evaluation:
Excel to Database

Includes automated data validation and Excel field/SQL merge codes.
Allows for upload(or update) to table or upload to stored procedure.

The SQL is auto-generated or you can customise the SQL if you require.

Could save you allot of time.

Cheers
 
brigzy said:
An easy option is use this free evaluation:
Excel to Database

Includes automated data validation and Excel field/SQL merge codes.
Allows for upload(or update) to table or upload to stored procedure.

The SQL is auto-generated or you can customise the SQL if you require.

Could save you allot of time.

Cheers
Click to expand...

Thanks for all the support from PCreview.

We have launched a new website today deatailing Excel to database techniques -

Excel to Database
 
Back
Top