Use an Excel variable in a stored procedure to update a temp table

• tmummert

  Mr or Mrs. 500

  Points: 527

  More actions

  June 7, 2010 at 8:45 pm

  #222474

  Is it possible to use an Excel value to update a table using a stored procedure? For example, I have a table where I need to input the month as an integer but the users do not have direct access to SQL. Is it possible for them to enter a value in an Excel cell, such as 4 for April, then run a macro in Excel that triggers a stored procedure that will use that value to populate the month column in a table?

  Thanks for your assistance,

  Trish

• S_Kumar_S

  SSCrazy Eights

  Points: 9037

  More actions

  June 23, 2010 at 12:32 am

  #1183734

  yes, you can do that but you'll need to get into excel programming a bit where in you make a database connection and call your proc.

  Online Trainer For SQL DBA and Developer @RedBushTechnologies with 18 yrs exp.