Re: How to maintain updated values?
Hi John,
Thanks for writing in our forums!
Importing data in MySQL for Excel means what the name implies, importing a snapshot of the data at the moment the action takes place.
The spreadsheet will not update automatically, you need to keep it in sync by re-importing.
If that is what you need you will have to go the standard data source way in Excel through ODBC and create a connection and a data source to the MySQL database. Not sure that will update the data after closing and reopening the spreadsheet but you may give it a try.
Best Regards.
====================================
Javier Treviño
MySQL on Windows Team
Subject
Views
Written By
Posted
1983
January 30, 2013 12:26AM
Re: How to maintain updated values?
1235
January 31, 2013 08:52AM
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.