Database Software

Getting the following errors :

Please tell me where I am going wrong?
Attached is the log file and snippets of datafile along with the control file !!
Also please direct me how can i upload 4900 records at one go?

-------------------------------------
SQL*Loader: Release 11.1.0.7.0 - Production on Fri Oct 14 03:06:06 2011

Copyright (c) 1982, 2007, Oracle. All rights reserved.

Control File: sample.ctl
Data File: Cities.csv
Bad File: Cities.bad
Discard File: none specified

(Allow all discards)

Number to load: ALL
Number to skip: 0
Errors allowed: 50
Bind array: 64 rows, maximum of 256000 bytes
Continuation: none specified
Path used: Conventional

Table CITY, loaded from every logical record.
Insert option in effect for this table: INSERT

Column Name Position Len Term Encl Datatype
------------------------------ ---------- ----- ---- ---- ---------------------
ID FIRST * , CHARACTER
NAME NEXT 35 , ' CHARACTER
COUNTRYCODE NEXT 3 , ' CHARACTER
POPULATION NEXT * WHT CHARACTER

Record 1: Rejected - Error on table CITY, column POPULATION.
ORA-01722: invalid number

Record 2: Rejected - Error on table CITY, column POPULATION.
ORA-01722: invalid number

Record 3: Rejected - Error on table CITY, column POPULATION.
ORA-01722: invalid number

Record 4: Rejected - Error on table CITY, column POPULATION.
ORA-01722: invalid number

Record 5: Rejected - Error on table CITY, column POPULATION.
ORA-01722: invalid number

Record 6: Rejected - Error on table CITY, column POPULATION.
ORA-01722: invalid number

Record 7: Rejected - Error on table CITY, column POPULATION.
ORA-01722: invalid number

Record 8: Rejected - Error on table CITY, column POPULATION.
ORA-01722: invalid number

Record 9: Rejected - Error on table CITY, column POPULATION.
ORA-01722: invalid number

Record 10: Rejected - Error on table CITY, column POPULATION.
ORA-01722: invalid number

Record 11: Rejected - Error on table CITY, column POPULATION.
ORA-01722: invalid number

Record 12: Rejected - Error on table CITY, column POPULATION.
ORA-01722: invalid number

Record 13: Rejected - Error on table CITY, column POPULATION.
ORA-01722: invalid number

Record 14: Rejected - Error on table CITY, column POPULATION.
ORA-01722: invalid number

Record 15: Rejected - Error on table CITY, column POPULATION.
ORA-01722: invalid number

Record 16: Rejected - Error on table CITY, column POPULATION.
ORA-01722: invalid number

Record 17: Rejected - Error on table CITY, column POPULATION.
ORA-01722: invalid number

Record 18: Rejected - Error on table CITY, column POPULATION.
ORA-01722: invalid number

Record 19: Rejected - Error on table CITY, column POPULATION.
ORA-01722: invalid number

Record 20: Rejected - Error on table CITY, column POPULATION.
ORA-01722: invalid number

Record 21: Rejected - Error on table CITY, column POPULATION.
ORA-01722: invalid number

Record 22: Rejected - Error on table CITY, column POPULATION.
ORA-01722: invalid number

Record 23: Rejected - Error on table CITY, column POPULATION.
ORA-01722: invalid number

Record 24: Rejected - Error on table CITY, column POPULATION.
ORA-01722: invalid number

Record 25: Rejected - Error on table CITY, column POPULATION.
ORA-01722: invalid number

Record 26: Rejected - Error on table CITY, column POPULATION.
ORA-01722: invalid number

Record 27: Rejected - Error on table CITY, column POPULATION.
ORA-01722: invalid number

Record 28: Rejected - Error on table CITY, column POPULATION.
ORA-01722: invalid number

Record 29: Rejected - Error on table CITY, column POPULATION.
ORA-01722: invalid number

Record 30: Rejected - Error on table CITY, column POPULATION.
ORA-01722: invalid number

Record 31: Rejected - Error on table CITY, column POPULATION.
ORA-01722: invalid number

Record 32: Rejected - Error on table CITY, column POPULATION.
ORA-01722: invalid number

Record 33: Rejected - Error on table CITY, column POPULATION.
ORA-01722: invalid number

Record 34: Rejected - Error on table CITY, column POPULATION.
ORA-01722: invalid number

Record 35: Rejected - Error on table CITY, column POPULATION.
ORA-01722: invalid number

Record 36: Rejected - Error on table CITY, column POPULATION.
ORA-01722: invalid number

Record 37: Rejected - Error on table CITY, column POPULATION.
ORA-01722: invalid number

Record 38: Rejected - Error on table CITY, column POPULATION.
ORA-01722: invalid number

Record 39: Rejected - Error on table CITY, column POPULATION.
ORA-01722: invalid number

Record 40: Rejected - Error on table CITY, column POPULATION.
ORA-01722: invalid number

Record 41: Rejected - Error on table CITY, column POPULATION.
ORA-01722: invalid number

Record 42: Rejected - Error on table CITY, column POPULATION.
ORA-01722: invalid number

Record 43: Rejected - Error on table CITY, column POPULATION.
ORA-01722: invalid number

Record 44: Rejected - Error on table CITY, column POPULATION.
ORA-01722: invalid number

Record 45: Rejected - Error on table CITY, column POPULATION.
ORA-01722: invalid number

Record 46: Rejected - Error on table CITY, column POPULATION.
ORA-01722: invalid number

Record 47: Rejected - Error on table CITY, column POPULATION.
ORA-01722: invalid number

Record 48: Rejected - Error on table CITY, column POPULATION.
ORA-01722: invalid number

Record 49: Rejected - Error on table CITY, column POPULATION.
ORA-01722: invalid number

Record 50: Rejected - Error on table CITY, column POPULATION.
ORA-01722: invalid number

Record 51: Rejected - Error on table CITY, column POPULATION.
ORA-01722: invalid number


MAXIMUM ERROR COUNT EXCEEDED - Above statistics reflect partial run.

Table CITY:
0 Rows successfully loaded.
51 Rows not loaded due to data errors.
0 Rows not loaded because all WHEN clauses were failed.
0 Rows not loaded because all fields were null.


Space allocated for bind array: 35840 bytes(64 rows)
Read buffer bytes: 1048576

Total logical records skipped: 0
Total logical records read: 64
Total logical records rejected: 51
Total logical records discarded: 0

Run began on Fri Oct 14 03:06:06 2011
Run ended on Fri Oct 14 03:06:12 2011

Elapsed time was: 00:00:06.18
CPU time was: 00:00:00.03



----------------------------------------------------------------------

my control file (sample.ctl):

load data infile 'Cities.csv'
into table city
fields terminated by ','
(id integer external,
name char(35) enclosed by "'",
countrycode char(3) enclosed by "'",
population integer external terminated by '\n'
)

my datafile (Cities.csv) (it contains 4900 records, but I am showing here just 4 records for ease)

3830,'Virginia Beach','USA',425257
3831,'Atlanta','USA',416474
3832,'Sacramento','USA',407018
3833,'Oakland','USA',399484


Thanks in advance!!