Re: Connecting Excel to mySQL on worksheet open
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.
Andrew
Subject
Views
Written By
Posted
4811
April 07, 2016 02:09PM
2207
April 08, 2016 10:51AM
2577
April 08, 2016 11:25AM
1778
April 11, 2016 09:43AM
1716
April 11, 2016 10:10AM
1792
April 12, 2016 01:50PM
Re: Connecting Excel to mySQL on worksheet open
1622
April 12, 2016 02:22PM
1671
April 14, 2016 09:49AM
1734
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.