OraFAQ Forum: Server Utilities » how to read data from text file and write in the database table

Home » RDBMS Server » Server Utilities » how to read data from text file and write in the database table (Oracle dbase 10g, Windows 2003 Server)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

how to read data from text file and write in the database table [message #294790]

Sat, 19 January 2008 04:07

dbhossain
Messages: 155
Registered: August 2007
Location: Dhaka

Senior Member

Dear Experts,

i have a text file name and location
as "D:\attendence.txt"

Contents of "attendence.txt" as
---------------------------------------------------------
ID -- Date --- InTime ----- OutTime

001 -- 18-JAN-2008 -- 10:15:10 AM -- 05:10:20 PM
002 -- 18-JAN-2008 -- 10:16:20 AM -- 04:30:20 PM
003 -- 18-JAN-2008 -- 09:30:18 AM -- 05:00:30 PM
004 -- 18-JAN-2008 -- 09:22:11 AM -- 04:10:30 PM
005 -- 18-JAN-2008 -- 08:00:15 AM -- 03:20:20 PM
-----------------------------------------------------------
now my database TABLE and its COLUMNS are as follows
----------------------
EMPID varchar2(10)
AttDate Date,
AttTime Date,
OutTime Date
-----------------------
Now i want to insert all data from attendence.txt in the above respective data base table column.

i dont have any idea b4 to do this job. Can anyone help me please?

Thank you.

---------------
Kamal Hossain

Report message to a moderator