Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.tools -> Re: Excel to Oracle8i
i sometimes use Excel to format insert statements. in an empty column, i create a formula something like:
="insert into mytable values ('"&A2&"','"&B2&"',"&C2&");"
if the formula gets to be longer than 255 characters, i will use a combination of formulas to split the generated insert statement into several columns.
i can then copy the column(s) and paste the values into a textpad, remove unneeded tab characters and save the file with a .sql extension. you can then execute the .sql file from sql*plus. don't forget the commit.
HTH
<snalion_at_hotmail.com> wrote in message news:8pu47u$pqk$1_at_nnrp1.deja.com...
> Hi. I need help to export data from Excel into Oracle8i. I have no clue
> in how to do this. Please help. Any help or hints would be appreciated.
> Thank You
>
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
>
Received on Fri Sep 15 2000 - 22:29:30 CDT