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
Batch Excel import into Oracle (Read 7816 times)
Gerrit-Jan Linker
YaBB Administrator
*****




Posts: 75
Batch Excel import into Oracle
14.09.06 at 22:29:39
 
Batch Excel import into Oracle
 
Markus from Germany asked the following question:
 
Question:
We are looking for a tool that allows us to import Excel datas directly into an Oracle database table and fully automatically in a batch-oriented way. Furthermore, it should be comfortable and easy to use (for PL-SQL-developers).
 
Is your product SQL*XL adequate? If so, how does it work?
 
Answer:
Yes, SQL*XL can be used to achieve this. It is very easy to use and PL/SQL developers will be able to use it with ease. Some VB knowledge is good if some further automation is required. PL/SQL may come in handy if a staging table is used to load the data into and a PL/SQL package could be used for the more elaborate import strategies.
 
To automate the batch-oriented insert see:
http://www.oraxcel.com/cgi-bin/yabb2/YaBB.pl?num=1133159596
 
To make the batch insert work automatically you can call the code from the Workbook_Open event as described in this post:
http://www.oraxcel.com/cgi-bin/yabb2/YaBB.pl?num=1146103864
Back to top
 
« Last Edit: 01.02.07 at 12:52:23 by Gerrit-Jan Linker »  

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