That is the problem I am having.Īnother thought.
#Conecting to a my sql server on mac drivers
My knowledge is limited with working with the ODBC drivers and how they interact with separate programs. I'm even willing to create a recordset object if required. I want to be able to pass insert, update and delete Also, these examples seem to work only for "select" queries. I need to be able to work with the object through code. Me in a non-worksheet reliant object such as an ADODB recordset used in PC based Excel. Unfortunately both of these examples use the queryTable object which appears to be reliant on worksheets. It appears as though many people have tried this but I can't see where anyone has been successful. I will be more than happy to share my code here once I have written it. I can handle the query strings, data manipulation and error handling.Īny help would be greatly appreciated. I am looking for the connection and SQL execution syntax only. I am willing to write Stored Procs that handle the bulk of the work as long as I can pass parameters back and forth between Excel and MySQLģ. I can write the SQL strings in VBA that then need to be run in MySQL and the results returnedĢ. This is very easily accomplished with ADODB and it's recordsets in the PC world but how do you accomplish this in the world of MAC?ġ. I want to be able to pass a query string to MySQL and have that string processed and the results What I mean is I do not want to rely on excel objects such as querytables. I DO NOT want to rely on worksheet or workbook functions for the DB connection.
#Conecting to a my sql server on mac for mac
I want to, through my configured ODBC driver and Excel 2016 for Mac VBA, set up a module to be able to Insert, Update and Delete records in a MySQL database living locally on my MacBook.Ģ.
VBA in the world of MACs is not nearly as robust as it is in the PC realmġ. You have to purchase ODBC drivers for everything but SQL Serverĥ. You have to manually set up an ODBC manager on MAC OS-X. ADODB is not an option for the MAC world - And from what I am reading, may never beģ. Development is much harder on a MAC than a PC - There are far less options for everythingĢ. If I am wrong some of the information was from posts that were quite old):ġ.
How do I connect to a MySQL database through Microsoft Excel 2016 VBA for MAC? Here is the knowledge I have gained throughout my research (and please correct me I have spent the past two days looking through Google to find the answer to the question.
0 kommentar(er)
