The feeds module, as suggested by RoloDMonkey seems indeed the way to go for re-importing updated data.
However, to export the data, you may want to consider the Forena module. Here is a quote from that page:
... built of the idea of using SQL to get data out of a database and use XHTML and CSS to format it into web reports.
Here is another quote from Reasons for considering Forena, related to the "CSV" in the question here:
Reports created by Forena ... can be saved (exported) as PDF documents with embedded graphs. Other supported formats for saving a report are CSV, XLS, DOC, HTML, etc.
The steps for creating such CSV files are:
- a connection to an external database (one time only, for each database).
- a custom SQL query (where you have the full power of SQL at your fingertips, and various extra features related to it provided by Forena, such as using report parameters, conditional SQL, etc).
- a custom report (either by an admin, or by just any regular user who is either familiar with creating what is called 'FRX files', or otherwise using the WYSIWYG report editor).
- saving the report in (eg) CSV format, using one of the typical hyperlinks to do so in a report.
These steps do not require any PHP coding.
If you're interested in an online demo site (prior to installing/testing Forena), then checkout these links:
Disclosure: I'm a co-maintainer (not owner ...) of this module,
I hope this does not violate the site's policy on self-promotion.