Hi,

I want to load data from .csv file to a table called dept in my database.

My .ctl file is as below:
load data
infile 'C:\Documents and Settings\prakasn1\Desktop\sqlloader\dept.csv'
into table dept
fields terminated by WHITESPACE optionally enclosed by '"'
trailing nullcols
(deptid,deptname)


And my .csv file as below:

1 sales
2 marketing
3 IT
4 finance

And the table is created newly and is empty:

desc dept
Name Null? Type
----------------------------------------- -------- ----------------------------
DEPTID NUMBER(6)
DEPTNAME VARCHAR2(20)

When i try to execute it through toad,it throws error as below:

OPEN TOAD ---> go to DATABASE menu ----->IMPORT ----->SQL*Loader Wizard
-->Use control file (existing one)
-->Then give the path of the .ctl file.
-->Then execute

ERROR:
SQL*Loader-500:
Unable to open file (C:\Documents and Settings\prakasn1\Desktop\sqlloader\dept.csv)
SQL*Loader-553: file not found
SQL*Loader-509: System error: The system cannot find the file specified.
SQL*Loader-2026: the load was aborted because SQL Loader cannot continue.

Even though the path is correct the above error is thrown.Please help. Thanx in advance.

Regards.