Import Data From FTP

Is it possible to import data, say once a day from a csv file in a FTP location.

We would also want to purge all existing data.