mysql

I was recently asked to set up a database for my father. I made the database and we loaded all the information into it but now we are having some issues getting power pivot to pull from this database. It is a typical godaddy mysql server. Much like this one Database name and...

Excel 2007 -- Windows 7 I've developed a pretty slick workbook that uses an ODBC connection to connect Excel with my mysql db. In sheet 2, it essentially dumps the data (personal information type data) from the db into a table. Sheet 1 takes that data and in each row lists a few pieces of...

I just upgraded to MySQL Connector/ODBC 5.2 from 5.1 and now my db connections don't work as I have wrong driver text in my functions. I've gone to their site and Googled for it but I cannot find it. Does anyone know what the new driver string is? This is the code I used successfully before, I...

I am working on some code that needs to add data into a database. I have no problems adding data when I am trying to execute one SQL statement at a time. My problem comes in when I attempt to execute 2 or more SQL statements at once. I know my syntax is correct, as I am able copy the value of...

I am using a simple SQL UPDATE statement to store userform textbox data into a database. The problem is that when a user types in the character " ' " or " \ " the data is not stored into the database. I don't receive an error it simply does not store the data. I thought it might be an...

I am looking for a way to connect to mySQL with a function so it can be reused passing different credentials each time it is called. Only thing is that I can't seem to use the connection after I run the SQLconnect function. I'm sure it's something easy but I don't know what to do. Can anyone...

I run a football (soccer) website and on it there is quite a bit of data and quite a few statistics such as league tables, goalscorers, appearance totals etc. which can change on a daily basis. Rather than change each page each day, the data is fed in to the website using PHP and MySQL. I...

I've got a good start, but i'm not that fluent in VBA, so I could really use a hand. I'm trying to pass variables from VBA to a query that is running against a MySQL database. here is the code so far... Sub QueryData_Update() Dim Client As Variant Set Sheets("ReportUS") = report Set...

Hi. I have received an excel workbook with about 2,000 products which need to be exported into a CSV format for use in a MySQL web store. My problem is that the way in which the spreadsheet is formatted seems to use the same column for multiple categories of data. For example, column A...

Hi I will soon have a excel sheet distributed between hundreds of users. When the excel is first opened, it gets connected to a mySQL database (and stays connected until excel application is closed) People then do queries, etc using the following code. ' connects to database when workbook is...

Hi all, hope someone can help me! I cannot get a connection to this MySql database for the life of me I have tried everything. this is where im at at the moment http://itc.virginia.edu/desktop/web/mysql/msaccess.html. ip, port and credentials are all good but I keep getting the 'Connection...

Hi there. I have an Excel Worksheet that I have included a Data Validation List to. The list is populated with items for sale. What I would like, is to have the user select any item from the list, and the cost of the item should be updated accordingly. No, I read somewhere that I can use the...

Have you seen this before and if so do you know how to stop this from happening? I am using "Microsoft Query" to import mySQL data into a spreadsheet. The data returned from the query is correct, but "Microsoft Query" is removing the "AS" statements. Thus the column headers are either the...

I'm using: Windows 7 x64, MS Excel 07, MySQL 5.1 (localhost), ODBC Connector 5.16 Current status I finally managed to use get data from MySQL into Excel Sheet. That works fine. Question Can I use a cell as reference in the MySQL query? 1 - SELECT * FROM users WHERE (id > 10) // works...

"Excel is not a database." We know the mantra and are living the reality. We have developed great and complex functions in Excel, often times with the help of the generous experts on this board. We use Excel craftily and lovingly. Our data are simple in structure: fixed number of columns, and...

I have an excelfile with 2 columns, ordernumber and articlenumber. I also have a MySQL database containing the same numbers and many more (like deliverydate, price and more). I established a connection Excel-MySQL using OLEDB and ODBC-DSN, so i can import the entire MySQL table in Excel. This...

Hi guys Software : WinXP and (Office) Excel 2007 I have a spreadsheet that creates a form and email based on information input - and checks for spare parts from a list Is it possible for this spreadsheet to check against a MySQL Dbase and - for example : there are 6 parts in that MySQL list...

I am creating a report in Excel using various ODBC connections. When I try to connect to a MySQL db it will not see the tables yet Access can see the tables. Is there something in excel that prohibits the user from seeing tables in a MySQL database?