Linker IT Software
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 9099 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:
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?
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:
To make the batch insert work automatically you can call the code from the Workbook_Open event as described in this post:
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