mysql

Hi guys, I've built a pretty basic database using MySQL Workbench - and I've uploaded a bunch of data. Now I am trying to pull data from my database into MS Excel using an ODBC connection via Excel's Get Data. However, after setting up the ODBC connection, I'm getting the following error for...

Hi, I have one table that contain information on clients for different years. The format of the table looks like this: ClientCode Year Status C001 2019 Done C001 2020 Done C001 2021 Todo K001 2020 Done K001 2021 Todo T002 2021 Done W001 2021 Todo An ODBC...

I have a MySQL database from which I request a recordset of clients, and then I filter the recordset for a specific client based on two fields: 1) client code and 2) year applicable. I then assign values from a userform's objects to the MySQL fields, and update that specific client's records to...

Hello, I've got problem. I receive phone number hashed by MD5 (00037b319ddf1495b2e7ae64e29a8ef5). I need to get this number from our mysql database. So mysql query is: SELECT MD5(c.mob) phone, c.mob phone1 FROM db_hu.hu_cust c WHERE MD5(c.mob) IN ('00f9758dd73300b4025ea916c8a3e024'); I...

Hi, i have the following which works but is there an easier way if the worksheet data matches the table? ie same no of columns as with 20+ columns to update it gets tedious typing it all out. Sub updateSQL() Application.ScreenUpdating = False var1 = Sheet3.Range("A2") Set cnn =...

Hi, not sure if this fits into the excel category but its what im using with ADODB Sub insertSQL() Application.ScreenUpdating = False var1 = Sheets("Sheet2").Range("A1") Set cnn = CreateObject("ADODB.Connection") cnn.Open MyConn Rw = 2 For i = 2 To Rw val1...

Anyone know how to convert Excel's 'ERF' function into a MySQL Function? Any help would be much appreciated. Apologizes in advance if this is a the wrong forum. In a jam and need some help! Thank you!!!

I'm using ADO to connect one workbook to another and then update certain fields. This works with no issue with the exception of dates. The workbook being updated has a "Timestamp" column formatted as "yyyy-mm-dd." No matter what I try, the update fails when the SQL is run with the error...

Hi, i used the following methods on this page to update an access table from excel (ADODB) but unsure the best or correct way to update an SQL table http://www.datawright.com.au/excel_resources/excel_access_and_ado_part_3.htm I have the following code: Sub SQLquery1() var1 =...

I need to write to multiple tables in my MySql database from excel (possibly 20 plus). I will be needing to use PK of certain tables i update as FK of others. I would really like to use Transactions to insure all information is update and if something errors out for any reason then i can...

Hello, is it possible to query (select) a mySql database (WordPress) with VBA ? and if so, how ? do I need to install some driver or somthing else ? Thanks !

Hi, i have some code which works fine with a set URL but i want to substitute it to use the workbook path ThisWorkbook.Path & "\MYDB\DATABASE1.mdb" the code below Sub getData1() dat1 = Range("I2").Value MYSQL = "SELECT * FROM `C:\test\MYDB\DATABASE1.mdb`.TABLE1 TABLE1WHERE TABLE1.EDAT="...

Hello, Can someone please help me I need to populate a combobox with data from mysql via vba how can i accomplish that. I'm not using a userform just a simple combobox. Thanks

Hello, I have question regarding downloading data from database in MySQL to Excel. For my colleagues I want to make application in Excel that connects to my tables in MySQL and download data. They will need to install my add-in and I do not want to bother them with installation of ODBC driver...

Hello, I have question regarding downloading data from database in MySQL to Excel. For my colleagues I want to make application in Excel that connects to my tables in MySQL and download data. They will need to install my add-in and I do not want to bother them with installation of ODBC driver...

I need to use Excel VBA connect MySQL database and run a simple query to get a count(*) from one table. But I don't know how to create a connection and run this query. Would anyone please help? Simple query just like below: select Count(*) from Table1 where Table1.date is not null;

Hi, I am completely stuck on this one, any help will be appreciated. I have a code which is supposed to do inserts/updates in database. I have connected to database using both (one commented out): Sub SQLConnection() Dim oConn As ADODB.Connection Set oConn = New ADODB.Connection...

Hi, a pivot is retrieving data from a MySQL dB in the cloud. but if it encounters in a field a value "=", then all following colomns remain blank. pls see below Columnrow V14 = "=" and columns W..AE are blank though there is data in the MySQL. Much appreciated if you could help me out. Cheers...

Hi Xcel gurus, I have a workbook which connecting to Mysql and getting data (In Pivot) no issues. Plan is to distribute this Workbook to my team so that they can able to see LIVE updates by Mysql. Issue : while testing, I have given this workbook to one of my team mate, and he is unable to...

I have an Excel project which uses MS ACCESS for data storage. Works fine. The issue is that ... The project is used by multiple persons in multiple locations, making synchronization of data tedious (each one has to export what they have done via proprietary files and similarly import changes...