mysql

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

Good day ! We have MySQL database where we update our data. Basically it is product database. But we also need to import data from there to Excel. I have used csv import so far and it works ok, but have some problems.. With that Excel sheet we like to color code some rows. ie. we look...

I think my Title has described my problem just fine. I do an InFile and want to know if there is any warnings or errors. How do I get the 'message' from MySQL into a VBA variable? I do a regular oconn.execute(qry) Thanks in advance! Lasse

I could not solve the above task, and i wanted to post a query on excel forum. But then i thought lets try once more changing delimiter AND I CAME BACK WITH SOLUTION for MY OWN Task. Anyway here it is (what i typed here before)...

Ladies and Gents, I've come across an extremely puzzling issue. I'm attempting to connect to a MySQL db through PowerQuery. I downloaded the mysql connector (originally version 6.6.5 but rolled back to 6.4.6 in an attempt to resolve this issue) and connected to the db. So far so good. It asks...

I am using SQL statements in VBA and I am having trouble joining 4 tables located in separate worksheets named "Stn", "Db", "Param" and "Ol" I have 4 tables: "Stn" with headers: Station_Name, Station_Abbreviation, Station_Order "Db" with headers: Station_Name, Sample_Date, Parameter_Name...

I'm struggling to get COUNTIFS to work when the dates I am tying to count are returned from a MYSQL table. The formula I have used is: =COUNTIFS(Smart!$Q$2:$Q$316,">"&(D12),Smart!$Q$2:$Q$316,"<"&(E12)) The actual dates are within the MYSQL table...

Hey guys, Trying to create a macro button that, when pressed, populates empty columns, based on a match between Part_ID in excel sheet called BOM and Part_ID in database table called materials joined with tables manufacturers and vendors The code is as follows: <code style="font-family...

Hey everyone, I haven't been able to find any similar examples online to what I'm trying to do.. hoping someone can help out here I have a database in MySQL called 'materialsdb' which holds tables for Materials, Manufacturers and Vendors. Materials is the main table of use, linked with foreign...

Hey everyone, So I have a materials database made up in mySQL, which holds linked tables for materials, manufacturers and vendors. I also have a Bill of Materials (BOM) in excel, in which there are empty columns for manufacturers, vendors, etc. The goal is to have a Macro button that, once...

Hello! I have a query to pass to mySQL database through Power Query. In essence, it looks like this: SELECT * FROM table WHERE col1 LIKE "%abc%" OR col1 LIKE "%xyz%" OR .... It is a part of more complex query that joins several tables . In my workbook I have a list of names ("abc", "xyz"...

Hello! I have a query to pass to mySQL database through Power Query. In essence, it looks like this: SELECT * FROM table WHERE col1 LIKE "%abc%" OR col1 LIKE "%xyz%" OR .... It is a part of more complex query that joins several tables . In my workbook I have a list of names ("abc", "xyz"...

Hi I am trying to create an excel speadsheet that will ask for a job number to be entered before retrieving data such as Job address, job type etc for that job and populate the page like a job sheet.. I am using Mariadb on a Synology nas to store the data.. I have read several threads here and...

Hello, I have written a standalone Excel application including a VBA macro called 'GetImage()' that creates and exports image files to a given folder on the server. Currently the macro can be initiated manually by clicking on a button within Excel, however I would like to know if it is...

Hi, I am trying to connect to a hosted MySQL database running 5.0.96 so I have installed the latest driver from MySQL site "Connector/ODBC 5.2.6". But I get this error: [Microsoft][ODBC Manager] Data source name not found and no default driver specified. I am able to connect if I use the ODBC...

Hello everyone! I am new to the forums and hope to learn a lot. Thanks in advance for taking your time to read the question and providing me with assistance. I am also currently researching the issue myself. I am currently working with a MySQL database and would like to somehow edit it and...

I was using ADODB code in Windows to fetch data from Mysql Database and it was working fine. However, I can not seem to get my Excel workbook (using ADODB) to work with Excel Mac 2011. After a lot of googling, I found an ODBC connector from Actual tech and I was able to fetch three rows using...

Hello, I have created the following "GetResult" VBA macro within Excel to apply a custom formula to the value of a given source cell within a hidden sheet, and display the result in a target cell on a visible target sheet: Sub GetResult(SourceCell as String)...

Hi To All, For one of my project I need to create a VBA module for export all data in active workbook's active sheet to MySql database table. At present I am using following code which is successfully doing as required: Public Sub TransMySql() Height =...

I've trawled the depths of Google (beyond page 20 of search results!) to try and find a solution to my current problem. Given that I haven't found a solution I'm tempted to believe that it's impossible but being an eternal optimist I've now decided to post something in here. Outline of what I...