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
Re: i dont have sql loader
Quote:
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
Quote:
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.