FTP/MySQL/CSV

ok, i have a CSV file sitting on a file server at my workplace. I would like this file to upload to another web server via FTP, then automatically import itself into a MySQL table...replacing any existing data. I figure I can use a ftp script on the web server to summon the data at a regular time and date, drop the existing data in the table, and import the new data...pretty much all in one script. Any ideas about how i would go about doing this? Any help would be appreciated!

PS-O yea, this will be in PHP.

thanks guys