Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: export & import data base without exp.exe & imp.exe
>
> 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