Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: export & import data base without exp.exe & imp.exe

Re: export & import data base without exp.exe & imp.exe

From: programmer <int.consultNOCAPITALS_at_macmail.com>
Date: Thu, 31 Jul 2003 15:05:04 +0100
Message-ID: <bgb85o$ni7$1@pheidippides.axion.bt.co.uk>


>
> can any one help me to export & import data base without exp.exe & imp.exe
>

Import the data into excel and write an excel formula to create an insert statement - eg.

in cell C2:
="insert into table1 values('"&A2&"','"&B2&"');"

Copy the formula down to the bottom of the data.

Copy all the formula cells to the clipboard.

Paste it into an SQLPlus window. Received on Thu Jul 31 2003 - 09:05:04 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US