MySQL Forums
Forum List  »  MySQL for Excel

Re: Connecting Excel to mySQL on worksheet open
Posted by: Andrew Ogilvie
Date: April 12, 2016 02:22PM

Thanks again Javier,

When I open the "Manage Stored Import and Edit Connection Information" settings, the worksheet I am having trouble with does not show up. I have three data sets I am connecting to this one workbook (different sheets).

When I reimport the data, the connections do all show up as expected.

If I save the file and open the settings.config file, the correct lines are listed in the <ImportConnectionInfosList>.

Still after closing and reopening the connection is broken.

One thing I just thought of, and sorry for not mentioning it before, is that this spreadsheet is on a network location, rather than local. The address never changes, but could this be an issue?

Thanks again, I appreciate the effort.


Options: ReplyQuote

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

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.