Home » SQL & PL/SQL » SQL & PL/SQL » Insert Script for Inserting values from Excel file (Oracle 10g Forms, WinXP)
Insert Script for Inserting values from Excel file [message #602018] Thu, 28 November 2013 23:13 Go to next message
stalin4d
Messages: 219
Registered: May 2010
Location: Chennai, Tamil Nadu, Indi...
Senior Member
Hi,

I want to Insert a 10 Rows from a Excel File into Oracle Table using only Insert Script, is there any possibilties!

Thanks in Advance...
Re: Insert Script for Inserting values from Excel file [message #602020 is a reply to message #602018] Thu, 28 November 2013 23:20 Go to previous messageGo to next message
Lalit Kumar B
Messages: 2544
Registered: May 2013
Location: World Wide on the Web
Senior Member
There are lot of ways to do this like
1. Importing file data using the tools.
2. MS Access link to the file using ODBC.
3. However, I find External Tables to be much useful and flexible.

stalin4d wrote on Fri, 29 November 2013 10:43
I want to Insert a 10 Rows from a Excel File


Wait, in my above post I did not realize you are talking about loading just 10 rows. I would rather prepare the insert script in the file itself and then copy paste in SQL*Plus and execute.

This is what I mean :-

In an excel cell, just like a formula generate insert statements :
 ="insert into employees values('" &B2 &"','" & C2 & "','"&D2&"');"


Above, B2, C2 and D2 are the data location in the file.

[Updated on: Fri, 07 March 2014 01:41] by Moderator

Report message to a moderator

Re: Insert Script for Inserting values from Excel file [message #602024 is a reply to message #602018] Thu, 28 November 2013 23:45 Go to previous message
stalin4d
Messages: 219
Registered: May 2010
Location: Chennai, Tamil Nadu, Indi...
Senior Member
Lalit Kumar B wrote on Fri, 29 November 2013 11:04
This is what I mean :-

In an excel cell, just like a formula generate insert statements :
 ="insert into employees values('" &B2 &"','" & C2 & "','"&D2&"');"


Above, B2, C2 and D2 are the data location in the file.


Yes we can use like this, thanks

[Updated on: Thu, 28 November 2013 23:46]

Report message to a moderator

Previous Topic: Please help me to implement this procedure
Next Topic: Using oracle wallets to move data from Oracle to teradata
Goto Forum:
  


Current Time: Mon Dec 22 04:55:09 CST 2014

Total time taken to generate the page: 0.14549 seconds