-
how to import data from a notepad text file
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 SQL*LOADER in Oracle.
-
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
-
i dont have sql loader
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
-
Re: i dont have sql loader
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.
-
Re: how to import data from a notepad text file
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.
funky...
"I Dont Want To Follow A Path, I would Rather Go Where There Is No Path And Leave A Trail."
"Ego is the worst thing many have, try to overcome it & you will be the best, if not good, person on this earth"
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|