Import 2 CSV files into MySQL

IN PROGRESS
Bids
26
Avg Bid (USD)
$74
Project Budget (USD)
$30 - $250

Project Description:
There are 2 files (with different layouts) that must be imported into a MySQL Database.

1. PHP5 Must be used.
2. The coding must be procedural and easy to understand/read

The functionality will be as follows:

1. Let user browse for file on his local hard drive
2. Check that the file is in the correct format.
3. Import the file into MySQL checking that the record being imported doesn't already exist in MySQL.

Other information:
The Structure of the MySQL Table (BANK) is attached. (banksql.gif)

Samples of the 2 files to be imported are attached:

2351.txt - Rules for Import:
Field Content to be filled with:
----- --------------------------
bank CC
date To be extracted from the Settlement Date field
description To me made up of "Reference"+"Email Address"+"Name"
amount To be taken from "ZAR"
balance Leave Blank
account Leave Blank
id Leave - AutoIncrement

Record only to be imported if the Settlement Date is given - if this field is blank, the record must not be imported.

Stmnt.csv - Rules for Import:
Field Content to be filled with:
----- --------------------------
bank CL
date To be extracted from "Date"
description To be extracted from "Description"
amount To be extracted from "Amount"
balance To be extracted from "Balance"
account Leave Blank
id Leave - AutoIncrement


I use Skype to communicate.
This is a very small and simple project, we expect to accept the lowest bid.

Skills required:
PHP
Additional Files: Stmnt.csv 2351.txt banksql.GIF
About the employer:
Verified
Public Clarification Board
Bids are hidden by the project creator. Log in as the employer to view bids or to bid on this project.
You will not be able to bid on this project if you are not qualified in one of the job categories. To see your qualifications click here.


Hire soner
$ 160
in 0 days
$ 200
in 4 days
$ 35
in 1 days
$ 200
in 3 days
Hire DesignSolutionSW
$ 30
in 2 days
$ 158
in 2 days
Hire phil999
$ 60
in 1 days
Hire festsoft
$ 45
in 2 days
Hire JesseLin
$ 30
in 1 days
$ 40
in 1 days