mysql

  1. D

    VBA Excel - MYSQL syntax to show columns correctly

    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...
  2. D

    VBA Excel - MySQL filter two fields error on Update - Run-time error '-2147467259 (80004005)'

    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...
  3. J

    VBA mysql SELECT MD5(tel)

    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...
  4. J

    An easier way than this to SQL update ?

    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 =...
  5. J

    Checking if a record exists already before using SQL INSERT ?

    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...
  6. G

    How-To Convert Excel's 'ERF' function into a MySQL Function

    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!!!
  7. M

    Using ADO to add date to another workbook

    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...
  8. J

    Need help with SQL query UPDATE from worksheet

    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 =...
  9. L

    Excel VBA connection to MYSQL using Transactions

    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...
  10. N

    vba and MySql

    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 !
  11. J

    How do i use Thisworkbook.path with this VBA

    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="...
  12. L

    Excel vba combobox and mysql

    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
  13. C

    Connect to a database without a 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...
  14. C

    Connect to MySQL without ODBC

    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...
  15. M

    How VBA connect MySQL database and run a simple query

    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;
  16. D

    Stuck on ADODB.connection MySQL

    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...
  17. L

    pivot from MySQL does not show data if there is a field containing "="

    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...
  18. M

    Excel To MySql : MySql drivers failed to install

    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...
  19. jdsouza

    Shift Local MS Access database file to Web Server

    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...
  20. M

    Error connecting to MySQL using VBA (3709 error)

    Hi all, Below is a code that will run every time a particular excel file is opened in order to block unauthorized access. For this the idea is to check the motherboard serial of the computer and verify if it is registered in a mysql database. If it is not registered it closes the file and...

Watch MrExcel Video

This Week's Hot Topics

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top