how to import data from a notepad text file

[iceman]

hello all

I have a set of text files, which I would like to import data into Oracle. The text file contains 5 columns and approx 100 rows.

Is there a way to import this data into Oracle in a new table.
Also if possible how to go about in Sql Server 7.0 ?


thnakx
regards
ICEMAN

[ggnanaraj]

use SQL*LOADER in Oracle.

[slimdave]

i would be tempted to just use a decent text file editor (like Ultraedit) to edit the lines by turning such lines as ...

1,3,01-dec-2002,john,smith

... into ...

insert into my_table values(1,3,to_date('01-dec-2002'),'john','smith');

i find it takes me less tha n a minute to do so, and the n the file can be pasted into SQL*Plus. Much faster for this data volume than writing/debugging sql*loader

[iceman]

hi

i have downloaded oracle 8.1.6 from oracle. I dont have sql loader in my program list !!!!

Have I made amistake somewhere in installation ????


thnakx
ICEMAN

[ggnanaraj]

Originally posted by iceman
I dont have sql loader in my program list !!!!

It is a command line utility. Type 'sqlldr' at the command prompt.

[abhaysk]

Originally posted by iceman
hello all

I have a set of text files, which I would like to import data into Oracle. The text file contains 5 columns and approx 100 rows.

Is there a way to import this data into Oracle in a new table.
Also if possible how to go about in Sql Server 7.0 ?


thnakx
regards
ICEMAN

use the utility provided by oracle/sql server....
Orcale : SQLLDR.exe
SQL Server 7.0 : BCP.exe

guess u r new....
better go thhru docs......

Abhay.