Re: Connecting Excel to mySQL on worksheet open
Hi Andrew,
Thanks for the information.
More than the information in connections.xml, I need the information in settings.config, as I told you in my last response:
Also please go in Windows Explorer to "%APPDATA%\Oracle\MySQL for Excel" and open the settings.config file. Please locate the <ImportConnectionInfosList> XML node and copy and paste the whole node here.
The <ImportConnectionInfosList> XML node contains some information needed by MySQL for Excel in order to pull data when doing a Data > Refresh.
Is the error also reproducible consistently with a different Excel Workbook that is macro-free for example? I mean if you use a standard .xls or .xlsx instead of .xlsm file.
Thanks.
====================================
Javier Treviño
MySQL on Windows Team
Subject
Views
Written By
Posted
4551
April 07, 2016 02:09PM
2111
April 08, 2016 10:51AM
2442
April 08, 2016 11:25AM
Re: Connecting Excel to mySQL on worksheet open
1692
April 11, 2016 09:43AM
1636
April 11, 2016 10:10AM
1685
April 12, 2016 01:50PM
1541
April 12, 2016 02:22PM
1567
April 14, 2016 09:49AM
1651
May 04, 2016 04:47AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.