Home » RDBMS Server » Server Utilities » how to read data from text file and write in the database table (Oracle dbase 10g, Windows 2003 Server)
how to read data from text file and write in the database table [message #294790] Sat, 19 January 2008 04:07 Go to next message
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




Re: how to read data from text file and write in the database table [message #294796 is a reply to message #294790] Sat, 19 January 2008 04:43 Go to previous messageGo to next message
vamsi kasina
Messages: 2107
Registered: October 2003
Location: Riyadh, Saudi Arabia
Senior Member
Have you tried SQL*Loader?

By
Vamsi
Re: how to read data from text file and write in the database table [message #294814 is a reply to message #294790] Sat, 19 January 2008 07:38 Go to previous message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
...Or external table?

Regards
Michel
Previous Topic: Importing from a pendrive
Next Topic: SQL Loader Doubt
Goto Forum:
  


Current Time: Sat Dec 03 07:56:54 CST 2016

Total time taken to generate the page: 0.28887 seconds