updating excel file data using vba from mysql

Question

Is it possible to have an excel sheet that gets updated from a mysql server using a specific query when ever it gets opened using VBA?

I am new to VBA and is it possible to monitor the data changes on the excel sheet while updating the sheet??

Thanks

Very hardly. It would probably be easiest to have a remote PHP script that generates a CSV file, and to download and open that — Pekka
– Pekka, Commented Feb 1, 2013 at 16:41
You need to set up data connection to the server. I have the same solution for Oracle DB, and it works pretty smoothly. — Peter L.
– Peter L., Commented Feb 1, 2013 at 16:45
@Pekka웃 thanks for the answer..but i want it to be from the excel file itself as will be easy for me to work easily by not opening nay other applications like browser.. — Prem_Kumar_S
– Prem_Kumar_S, Commented Feb 1, 2013 at 16:45
@Prem_Kumar_S no any other applications needed: as soon as query is set up, you just need to refresh it. That's it. Fro my case DB select is linked as source data for pivot table. — Peter L.
– Peter L., Commented Feb 1, 2013 at 16:47

John Bustos · Accepted Answer · 2013-02-01 16:48:43Z

2

If you use the Data > Get External Data toolbar to set up the MySQL data pull, you can then set the workbook to refresh upon opening - Here's a link that shows the very basics.

As for tracking / moitoring changes, you'd have to be more detailed about how you'd like that to happen... As a general rule, it's not very easy to do.

Hope this helps!!

answered Feb 1, 2013 at 16:48

John Bustos

19.7k18 gold badges102 silver badges162 bronze badges

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

2 Comments

Prem_Kumar_S Over a year ago

get external data works based on DSN connection... I want this to be done with a connection string as it will be easy to access any where in my network...

John Bustos Over a year ago

What about Data > From Other Sources > Other\Advanced > in connection tab Use Connection String

Collectives™ on Stack Overflow

updating excel file data using vba from mysql

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related