Forum for MySQL for Excel. http://forums.mysql.com/list.php?172 Tue, 21 May 2013 01:33:49 +0000 Phorum 5.2.19 http://forums.mysql.com/read.php?172,585180,585180#msg-585180 http://forums.mysql.com/read.php?172,585180,585180#msg-585180 jim scelzi MySQL for Excel Thu, 09 May 2013 01:12:55 +0000 http://forums.mysql.com/read.php?172,584669,584669#msg-584669 http://forums.mysql.com/read.php?172,584669,584669#msg-584669 Asiri Godage MySQL for Excel Fri, 26 Apr 2013 21:40:41 +0000 http://forums.mysql.com/read.php?172,584160,584160#msg-584160 http://forums.mysql.com/read.php?172,584160,584160#msg-584160
I have connected my excel 2013 with a mysql database, using MySQL for Excel. I don't have any problem downloading fields with values containing greek characters. However, when i try to update a value, using greek characters, the data that reaches the server are not correctly encoded (probably).

I have tested that with mysql workbench i can do the same thing successfully, so there is no problem on the server side.

So, i'm stuck because i cannot think of a way to check/alter the encoding used during the transactions of MySQL for Excel.

Any help would be appreciated.]]> Vyron Dokimakis MySQL for Excel Fri, 26 Apr 2013 21:48:26 +0000 http://forums.mysql.com/read.php?172,581966,581966#msg-581966 http://forums.mysql.com/read.php?172,581966,581966#msg-581966
I use Excel 2007 and MySQL5.6. I have established connection between Excel and MySQl
using MySQLforExcelConnection (the button at Data ribon tab).

Due to the fact that I have many tables and I must do it for all tables in Database, I am searching a way so every time I open excel file, the connection to be established automatically, update all the tables in excel and also the small window
"Revert Data" "Commit changes" to remain active.
It must be as if I did it manually.

Thank you for help

Christos]]> Christos Giannoukos MySQL for Excel Wed, 03 Apr 2013 16:37:21 +0000 http://forums.mysql.com/read.php?172,581945,581945#msg-581945 http://forums.mysql.com/read.php?172,581945,581945#msg-581945 I have installed MySQL for Excel as part of a download of MySQL.
I am using Excel 2010 on a Windows XP OS.
I see the MySQL for Excel add-in in the Data panel of my Excel workbook.
However, clicking teh add-in yields no response.

I have uninstalled and re-installed the add-in a number of times.
I see it in the COM Add-Ins list. The add-in is ticked in the COM Add-ins avaiable list.
The "Ignore other applications...(DDE)" option is not selected in the Options>Advanced>General optionslist.

Is there anything else to check for to get the add-in to work?
Is there a log that captures errors the add-in may be recording while trying to launch?


Any and all advice is appreciated.

Thank you,
Kelly]]> Kelly Robinson MySQL for Excel Wed, 03 Apr 2013 16:34:42 +0000 http://forums.mysql.com/read.php?172,581305,581305#msg-581305 http://forums.mysql.com/read.php?172,581305,581305#msg-581305
When I copy/paste 10 lines in a table containing 5 lines, I have a Excel message concerning protected cells.

I have to insert the lines one by one and then make the copy/paste operation.

Is it the way to do it or is there another way copy/paste the 10 lines in one time ?

Best regards

Arnaud]]> Arnaud Velard MySQL for Excel Thu, 14 Mar 2013 17:04:44 +0000 http://forums.mysql.com/read.php?172,581208,581208#msg-581208 http://forums.mysql.com/read.php?172,581208,581208#msg-581208
I discovered MySQL for Excel last week which is just what I need.

But I have a small problem.

When I edit a table with an expression containing an apostrophe, a backslash is inserted before it.
For example : "Arrêt d'urgence" becomes "Arrêt d\'urgence" in the table after I commit.

I noticed by clicking on Show details in the box validating the operation that the following is executed :
"001: UPDATE `test`.`liste_defauts` SET `LIBEL_DEFAUT`='Arrêt d\\\'urgence variateur' WHERE `ID`=19;"
(Three \ before the ')

Best regards.

Arnaud]]> Arnaud Velard MySQL for Excel Thu, 14 Mar 2013 08:10:24 +0000 http://forums.mysql.com/read.php?172,580792,580792#msg-580792 http://forums.mysql.com/read.php?172,580792,580792#msg-580792 sushaanth srirangapathi MySQL for Excel Wed, 13 Mar 2013 17:19:41 +0000 http://forums.mysql.com/read.php?172,580726,580726#msg-580726 http://forums.mysql.com/read.php?172,580726,580726#msg-580726 I installed MySQL for Excel and tried to set 'MySQL.ForExcel' Add-in to be active. It showed in Load Behavior that 'Not loaded. A runtime error occurred during the loading of COM Ad-in.'.

I uninstalled/re-installed many times but still got the same error.
Could you give the advice? Thanks.]]> Naruemon Tantrawiwat MySQL for Excel Tue, 14 May 2013 15:59:07 +0000 http://forums.mysql.com/read.php?172,580443,580443#msg-580443 http://forums.mysql.com/read.php?172,580443,580443#msg-580443
Creating MySQL Table "propertyowner12_7_07" with query...

CREATE TABLE `performance_schema`.`propertyowner12_7_07`
(
`OWNCLASS` Varchar(12) not null,
`OWNCLSCD` Integer null,
`OWNR_NAM1` Varchar(45) null,
`OWNR_NAM2` Varchar(45) null,
`PARCELID` Varchar(25) primary key,
`PROPTYPE` Varchar(25) null,
`PROP_CITY` Varchar(12) null
)

MySQL Error 1142:
CREATE command denied to user 'root'@'localhost' for table 'propertyowner12_7_07']]> Ed Janney MySQL for Excel Mon, 04 Mar 2013 17:27:43 +0000 http://forums.mysql.com/read.php?172,579030,579030#msg-579030 http://forums.mysql.com/read.php?172,579030,579030#msg-579030 i can't find this component on (file -> option -> rapid access bar) ?
how can i add it on data menu ?

may some one help please ?

thanks in advance]]> kam bah MySQL for Excel Mon, 04 Mar 2013 17:20:43 +0000 http://forums.mysql.com/read.php?172,578589,578589#msg-578589 http://forums.mysql.com/read.php?172,578589,578589#msg-578589 I need it because a Programm is already using it.]]> Roland Petri MySQL for Excel Tue, 12 Feb 2013 23:01:54 +0000 http://forums.mysql.com/read.php?172,578515,578515#msg-578515 http://forums.mysql.com/read.php?172,578515,578515#msg-578515 MySQL 5.5.30 Community Server 64-bit with all the connectors.
Windows 7 Professional 64-bit.
MS Office 2013 64-bit.

PROBLEM:
MySQL Installer will not install MySQL for Excel 1.1.0.

On MySQL Installer's "Check Requirements" screen, the radio buttons are checked for Video Studio Tools for Office 2010 Runtime and for Microsoft .NET Framework 4 CLient. However the radio button for Microsoft or greater Excel 2007 is not checked.

A message says Excel 2007 or greater is not detected on my machine.

However, my machine (my personal laptop) does have a proper install of Excel 2013 64-bit.

REQUEST:
How can I install MySQL for Excel 1.1.0?

NOTE:
In a past time when I had Office 2007, then MySQL for Excel installed and performed beautifully on this same laptop.

Thank you.]]> Scott Bailey MySQL for Excel Mon, 04 Mar 2013 17:22:45 +0000 http://forums.mysql.com/read.php?172,578169,578169#msg-578169 http://forums.mysql.com/read.php?172,578169,578169#msg-578169 john newman MySQL for Excel Thu, 31 Jan 2013 14:52:01 +0000 http://forums.mysql.com/read.php?172,578072,578072#msg-578072 http://forums.mysql.com/read.php?172,578072,578072#msg-578072 Everything else seems to be working fine, except MySQL for Excel. After browsing through a set of alternatives with our computer support, we found that MySQL for Excel actually works with computer support's profile, but not with my profile. (i.e. on support’s account MySQL for Excel Add-In works, on my account nothing is visible inside Excel)

Anyhow, the control panel shows (also on my account) that MySQL for Excel is installed.

Changing the administrative rights appears not as a feasible option. Are the any other ways to get MySQL for Excel running on my account?

Tarmo]]> Tarmo Räty MySQL for Excel Mon, 28 Jan 2013 22:21:29 +0000 http://forums.mysql.com/read.php?172,577921,577921#msg-577921 http://forums.mysql.com/read.php?172,577921,577921#msg-577921 I have uninstalled and reinstalled MySql for Excel and the VSTO and get the same error.]]> David Osterman MySQL for Excel Sat, 26 Jan 2013 06:10:14 +0000 http://forums.mysql.com/read.php?172,577822,577822#msg-577822 http://forums.mysql.com/read.php?172,577822,577822#msg-577822
When I try to connect to my local database on MySQL for Excel, it says wrong password.
If I try to test the same connection through MySQL for Excel, type the same password it works.
If I try to connect to the database thorugh WorkBench, type the same password it works.
If I try to connect to the database thorugh the command line, type the same password it works.

I've even added some new users with total privileges and the same happens.

Any ideas?]]> Amilton Mirtao MySQL for Excel Wed, 20 Mar 2013 16:49:23 +0000 http://forums.mysql.com/read.php?172,577641,577641#msg-577641 http://forums.mysql.com/read.php?172,577641,577641#msg-577641
The add-in works as expected in Excel 2007 SP3 and will connect successfully to a connection set up in MySQL Workbench (5.2.44 CE).

In Excel 2013 I see the MySQL for Excel button in the Data Ribbon, but when I click it, it changes status (enabled / disabled) but the sidebar does not appear.

There is nothing that appears of any use in the log file. There are only entries for startup and shutdown which correspond to starting and exiting Excel 2013, e.g. "MySQLForExcel Information: 1 : MySQL for Excel Startup" with a timestamp.

What can I do to get MySQL for Excel working for me?

Tom]]> Tom Raggett MySQL for Excel Fri, 05 Apr 2013 01:29:58 +0000 http://forums.mysql.com/read.php?172,577438,577438#msg-577438 http://forums.mysql.com/read.php?172,577438,577438#msg-577438
- I have Mysql for Excel in my Add/Remove programs
- I have files in program files(x86)\mysql\mysql for excel
- ODBC and everything installed and works fine

Where is the button? I went to the mysql for excel directory and tried running the file Mysql.ForExcel.vsto (the vsto deployment manifest file). This opens a program that says it is installing office addons. Looks promising but it fails halfway through with complaint that it can't download file:///C:\program files (x86)/mysql/mysql for excel 1.1.0/mysql.forexcel.dll.config

That file (.config) does not exist in my installation. Is it supposed to?

If I fake it so it goes further then it complains about something called resources/mysql-for-excel.ico. That file does not exist either in my installation. is it supposed to?


I would love (and need) to get this add-in running ASAP. Any help is greatly appreciated. thanks!]]> Bill Huneke MySQL for Excel Sat, 19 Jan 2013 00:43:15 +0000 http://forums.mysql.com/read.php?172,577177,577177#msg-577177 http://forums.mysql.com/read.php?172,577177,577177#msg-577177
Why is 'Export Excel Data to New Table' greyed out?]]> Michael Michon MySQL for Excel Thu, 17 Jan 2013 21:26:43 +0000 http://forums.mysql.com/read.php?172,576868,576868#msg-576868 http://forums.mysql.com/read.php?172,576868,576868#msg-576868
I have Excel 2010 installed in the new Windows8 (64bit) OS. I have looked for the add-in in the Data Tab and in the add-in sections and have not found anything.

Does anyone have any ideas?
Thanks for your help.
Tom]]> Tom Sorger MySQL for Excel Thu, 17 Jan 2013 21:25:34 +0000 http://forums.mysql.com/read.php?172,576805,576805#msg-576805 http://forums.mysql.com/read.php?172,576805,576805#msg-576805
I downloaded MySQL for Excel to be able to edit my database on my web hosting server. A database table I need to edit has some columns with foreign keys which prevents me from doing the edits in PhpMyAdmin. In PhpMyAdmin I normally would export a table, make the edits in Excel, then empty the table, and import the edited table data. But the foreign keys in one of my tables prevents me from being able to do that in PhpMyAdmin since it gives a "cannot truncate" error message.

I'm having the same problem with MySQL for Excel. There is one column of text in this database table that I need to edit. I can use the "Import MySQL Data" option of MySQL for Excel to select and open the one table column in Excel. But I need to edit the data, not append (add new rows of data) to the table.
I cannot use the "Edit MySQL Data" option since I get an error message that says: "Unrecognized Guid format" (I think the column with the foreign keys is titled "guid"). I also cannot select the one table column to open/edit with the "Edit MySQL Data" option since the window that opens does not enable me to select individual columns (it has all the columns selected and I cannot scroll to view the columns to the right of the visible window.

I don't know much about MySQL so I was hoping someone would have advice on how I can edit a MySQL database table when the foreign keys data of some of the table columns are blocking me from doing the edits the normal ways.

I downloaded the MySQL Workbench but I don't know how to write scripts to make the edits.

Any advice would be greatly appreciated. Here is the MySQL page that I got the downloads from: http://www.mysql.com/why-mysql/windows/

Thank you!]]> G C MySQL for Excel Wed, 16 Jan 2013 00:46:07 +0000 http://forums.mysql.com/read.php?172,576526,576526#msg-576526 http://forums.mysql.com/read.php?172,576526,576526#msg-576526
When I go to Developer ribbon in Excel and open COM Add-ins, MySQL.forExcel appears as installed along with other addins I have installed (e.g. PowerPivot). However, the checkbox on the MySQL.forExcel is unchecked, I check it and press OK, but nothing happens (the application button does not appear in the Data ribon) - when I open COMM Add-ins again, it appears unchecked again...

So, there seems to be a problem in loading application which seems to be properly installed.

Thanx for any advice.]]> Duje Bonacci MySQL for Excel Wed, 16 Jan 2013 00:21:55 +0000 http://forums.mysql.com/read.php?172,575649,575649#msg-575649 http://forums.mysql.com/read.php?172,575649,575649#msg-575649
I was wondering, where I can find the Source for the MySQL for Excel Add-In.
Can you point me to the package, which includes the code?

Thanks in advance.

Michael]]> Michael Schoen MySQL for Excel Tue, 11 Dec 2012 17:25:28 +0000 http://forums.mysql.com/read.php?172,574510,574510#msg-574510 http://forums.mysql.com/read.php?172,574510,574510#msg-574510 r baker MySQL for Excel Sat, 08 Dec 2012 00:30:39 +0000 http://forums.mysql.com/read.php?172,574293,574293#msg-574293 http://forums.mysql.com/read.php?172,574293,574293#msg-574293
Tonight I was so happy to discover that this tools exists, however it looks like there is a bug on French systems which disapoints me a lots... as you may know in France, all the floating numbers are written like : 12,45€ instead of 12.45€

This gives the following querry when I try to commit an entry :

Deleting 0, Inserting 1, Updating 0 row(s) with the following SQL statement(s):
001: INSERT INTO `world`.`country` (`Code`,`Name`,`Continent`,`Region`,`SurfaceArea`,`IndepYear`,`Population`,`LifeExpectancy`,`GNP`,`GNPOld`) VALUES ('TK','Tans','Africa','Eastern Africa',390757,1980,11669000,37,8,5951,8670)
MySQL Error 1136:
Column count doesn't match value count at row 1


The value 37,8 is considered as 2 different colums instead of one single number. Does anybody know a workaround?]]> Tansu KAYRAK MySQL for Excel Sat, 08 Dec 2012 00:01:09 +0000 http://forums.mysql.com/read.php?172,573927,573927#msg-573927 http://forums.mysql.com/read.php?172,573927,573927#msg-573927
I need to use Excel to edit my DB, and MySQL for EXCEL work great for me.
But, I have a issue when I close the worksheet. When I open it again, the connection is broken and I cannot use the same sheet to edit MySQL DB,I have to re-connect and Excel create another sheet with MySQL data.
I need some way, that use the same sheet.

Maybe a remote connect? But how to do this?]]> Abdo Souza MySQL for Excel Fri, 07 Dec 2012 21:37:56 +0000 http://forums.mysql.com/read.php?172,572657,572657#msg-572657 http://forums.mysql.com/read.php?172,572657,572657#msg-572657 Qiaochai Du MySQL for Excel Sat, 24 Nov 2012 18:58:12 +0000