0

I currently create views and connect them to my excel files. However, when I do ad hoc analysis I just query and copy results into excel. Is there a way to use VBA to query the server directly?

not sure what to do once I right click and view code

Improve this question
2
  • 1
    I would change your question to specify MSSQL instead of SSMS. SSMS is SQL Server Management Studio: the IDE for browsing MSSQL (Microsoft SQL Server). Commented Oct 2, 2024 at 1:59
  • 1
    This question is similar to: Using Excel VBA to run SQL query. If you believe it’s different, please edit the question, make it clear how it’s different and/or how the answers on that question are not helpful for your problem. Also, you can't query SSMS. SSMS is a tool for writing SQL for SQL Server (the actual database engine that gets queried). It's important to learn the difference between the database engine (SQL Server) and the tool used to manage it (SSMS). They're not the same thing. Commented Oct 2, 2024 at 3:24
Related questions
785
What is the best way to auto-generate INSERT statements for a SQL Server table?
2096
Inserting multiple rows in a single SQL query?
330
SQL Server: Query fast, but slow from procedure
Load 7 more related questions Show fewer related questions

0

Reset to default

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.