"MYSQL for Excel" automating connection to database via macro
Posted by: uday sagar
Date: October 02, 2015 02:47PM

Hi All,

I have to automate couple of things using macros in excel. I can do these functionalities using the software by clicking the buttons and giving database connection details manually.

But I want all these things to be taken care by a macro that runs on the excel startup.

I want a macro that takes care of the following functionalities via VBA Code(macro) using "MYSQL for Excel" software/addin for excel.

1. Connect to database
2. load all rows of a specific table in edit mode such that addition of new rows in excel should save back in database.

Thanks,
Uday Sagar.

Options: ReplyQuote


Subject
Views
Written By
Posted
"MYSQL for Excel" automating connection to database via macro
1671
October 02, 2015 02:47PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.