![]() Password = "12345678" ' Enter your password hereĬonn.Open "DRIVER=" _ User_id = "prueba" ' enter your user ID here ![]() ![]() Server_name = "127.0.0.1" ' Enter your server name here - if running from a local computer use 127.0.0.1ĭatabase_name = "pruebas" ' Enter your database name here See /downloads/connector/odbc/3.51.html or google "MySQL ODBC 3.51 Driver"ĭim sqlstr As String ' SQL to perform various actions ' 1)In VBE you need to go Tools/References and check Microsoft Active X Data Objects 2.x library ' PLEASE DO THE FOLLOWING BEFORE EXECUTING CODE: ' Majority of the original code adapted from Carlmack ' VBA to perform various actions on MySQL tables using VBA The example I'm using this part of code: Option Explicit The first thing I'm doing is connect me to MySQL so I found this page: Hello to all participants, must extract an excel sheet data from MySQL once extracted these data excel sheet processed with many functions, the result of that calculation must be stored in MySQL. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |