Linker IT Software
Google
Web www.oraxcel.com
menubar-top-links menubar-top-rechts
Home Help Search Login
Welcome, Guest. Please Login.
SQL*XL: Database to Excel bridge litLIB: Excel power functions pack ExcelLock: Locking and securing your valuable Excel spreadsheets encOffice: Protect your Excel file easy and safe encOffice: Protect your Excel file easy and safe
Pages: 1
Export Excel to Oracle (Read 8850 times)
daniel50096230
YaBB Newbies
*


I Love SQL*XL

Posts: 1
Export Excel to Oracle
20.08.08 at 11:12:56
 
I would like to export my excel data into oracle.Is there any sample codes for me to refer???Because this is the first time for me to try this.
Back to top
 
 
Email   IP Logged
Gerrit-Jan Linker
YaBB Administrator
*****




Posts: 75
Re: Export Excel to Oracle
Reply #1 - 20.08.08 at 19:41:06
 
Hi,
 
Yes there is some code on this forum to refer to. It is however extremely simpel to make exactly the code you need. Just record the running of an insert.  
 
Please read this topic for further information about automating the insert of multiple records from Excel into Oracle. The SQL*XL screen uses the insertrecordset method. Searching in the google box above also presents all the pages about this function.
 
http://www.oraxcel.com/cgi-bin/yabb2/YaBB.pl?num=1133159596/0
 
If you need any further help with this, please let me know.
Back to top
 
 

Gerrit-Jan Linker
Linker IT Software
Email WWW Gerrit-Jan Linker   IP Logged
Pages: 1