execute an SQL procedure from excel

kanikakanika Member Posts: 246
edited 2015-06-01 in SQL General
Hi experts!!

Does anyone know how to execute an SQL procedure from excel?

I have procedures that create tables in SQL Server. These tables are used in views then I see in excel.
I need to implement these procedures to update the data in Excel.

Is it possible?

thanks!!

Answers

  • bbrownbbrown MAMember Posts: 3,227
    Have you looked into using ADO via VBA?
    There are no bugs - only undocumented features.
  • kanikakanika Member Posts: 246
    Thank you so much, and I solved it with microsoft query
Sign In or Register to comment.