MySQL Forums
Forum List  »  MySQL for Excel

Re: How to maintain updated values?
Posted by: Javier Treviño
Date: January 31, 2013 08:52AM

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

Options: ReplyQuote


Subject
Views
Written By
Posted
2054
January 30, 2013 12:26AM
Re: How to maintain updated values?
1269
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.