csv to csv to mysql

Make csv file to upload dump file to mysql. I need the easiest and most automatic procedure to export data daily. from ([login to view URL]) to (clf_ads). matching field values to (clf_ads). keeping clf_ads headings. One column (cityid) will need to be queried from file ([login to view URL]) column (city) and ([login to view URL]) heading . Column Heading (subcatid) will need to be queried from ([login to view URL]) heading column Category and from ([login to view URL]) heading subcatid and subcatname. Please see [login to view URL] attachment for notes and instructions.