Re: Q) How to use TOAD to import only data into a table?

Mother of God,

AFAIK TOAD does not support import. I may be wrong on this.

Save your excel files as a csv files. Read from the csv files using PLSQL and
insert them into the database. I think there are some inbuilt packages supplied to read from text files

Alternatively you can use SqlLoader supplied by Oracle to read from csv or text files.

Search the deja forums for this. Type "import from Excel" or "Import from csv" in the oracle server forum

"Mother of God" <mother_at_god.ie> wrote in message news:<YCYF7.6407$8s4.27272_at_news.indigo.ie>...
> I am something of a newbie but am trying to do something very simple.
> I am looking to find a very easy way to import / paste(?) data into an
> Oracle database. The data is generally stored in either excel
> spreadsheets or text files.
>
> Eg.
>
> Say I have a table named 'CUSTOMER' with two columns 'FIRSTNAME' and
> 'LASTNAME'.
>
> Then lets say I have a text file with the following
>
> smith,john
> jones,mick
>
> etc. etc.
>
> Is there an easy way to simply import this information into the
> database table using toad? As it stands I am using excel formulae to
> generate insert statements and pasting them into a SQL window in TOAD
> to execute.
>
> I know this is a simple question but trust me this would help me a
> great deal.
>
> Thanks
Received on Tue Nov 06 2001 - 23:58:08 CST