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"
Reply With Quote