MySQL Forums
Forum List  »  MySQL for Excel

Re: Connecting Excel to mySQL on worksheet open
Posted by: Javier Treviño
Date: April 12, 2016 01:50PM

Hi Andrew,
What comes to mind is the fact that MySQL for Excel currently has a known limitation in the way it handles Workbook Connection information.

As you can see it is storing it in the settings.config file and it stores the Workbook location. If you take the Workbook and move it somewhere else, then the "link" is broken... so as you can see this needs to be enhanced so the "link" is not broken when the Workbook is moved to a different location.

Can you please inspect the <ImportConnectionInfosList>, locate the ExcelTableName you are trying to Refresh and tell me if the WorkbookFilePath is not corresponding to the path the file currently has?

Currently you can go to the Global Options (accessible after you connect to a mysql server, using the "Options" button at the bottom of the side-bar), and click on "Manage Stored Import and Edit Connection Information..." and see what entries there are in red, those ones have "missing" or "broken" links.

You can try editing the information yourself in the settings.config and see if that fixes the link.

Best regards.

Javier Treviño
MySQL on Windows Team

Options: ReplyQuote

Written By
Re: Connecting Excel to mySQL on worksheet open
April 12, 2016 01:50PM

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.