MySQL Forums
Forum List  »  MySQL for Excel

Re: Connecting Excel to mySQL on worksheet open
Posted by: Javier Treviño
Date: April 11, 2016 09:43AM

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.


Javier Treviño
MySQL on Windows Team

Options: ReplyQuote

Written By
Re: Connecting Excel to mySQL on worksheet open
April 11, 2016 09:43AM

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.