Execute .SQL file with VBA

Question

I would like to know if there is any VBA code which allows me to execute .sql files by clicking a button in Excel?

I've been surfing different webs, but all of them showed code which consists into write the SQL query in the macro, despite it isn't what I wanted. So I have stored .sql scripts as files in different folders on my computer and what I want is to run this script by clicking a button in Excel using VBA.

Wils Mils · Accepted Answer · 2020-07-13 07:59:36Z

0

Short answer is no. There is no magic button in Excel that does that. Easiest that I can think of is run/import that .sql to MySQL, SQL Server, Postgres, etc. to become a database. Example using MS SQL Server:

How do I import a .sql data file into SQL Server?

Once you run successfully that .sql into a DBMS, you may use built-in tools of that DBMS to export the tables into Excel. See the link below as an example:

How to Import and Export SQL Server data to an Excel file

It may not be as easy as pressing a button but not as tedious as hardcoding it. I hope it helps.

answered Jul 13, 2020 at 7:59

Wils Mils

6334 silver badges9 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

ignacio diaz Over a year ago

Hey, thanks a lot for your answer! Indeed, I have created these scripts in SQL Server and as I have to execute some codes in VBA which update this databases. I wanted to find this code to open those .sql files and run them. I know you have for instance the VBA code "Do.Cmd.OpenQuery" to open Access db and run any query save in this Access db.

Collectives™ on Stack Overflow

Execute .SQL file with VBA

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related