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
Upload Excel spreadsheet data into Oracle (Read 8130 times)
Gerrit-Jan Linker
YaBB Administrator
*****




Posts: 75
Upload Excel spreadsheet data into Oracle
03.01.07 at 07:36:06
 
Upload Excel spreadsheet data into Oracle
 
If you are lookoing to upload Excel spreadsheet data into an Oracle database and you do not want mess around with SQL*Loader you can use SQL*XL to do the job. This Oracle Excel spreadsheet application is easy to use and quick in uploading the spreadsheet data. SQL*XL can upload spreadsheet data into any database: Oracle, MySQL, SQL Server, Access, etc...
 
SQL*XL is Oracle Excel spreadsheet software which lets you upload Excel spreadsheet data into Oracle just with a button click. Just specify to which table you want to upload the data and specify the column mappings. The SQL*XL screen to use is the Insert Multiple Rows screen.
 
To try this out for yourself please request an evaluation of SQL*XL Universal at:
http://www.oraxcel.com/downloads
 
More info:
*SQL*XL product page
http://www.oraxcel.com/projects/sqlxl
*Insert Excel data into a database
http://www.oraxcel.com/projects/sqlxl/help/techniques/bulk_insert.htm
*Multiple Rows Insert dialog
http://www.oraxcel.com/projects/sqlxl/help/dialogs/insert_multi/index.html
*Automate the upload process using the InsertRecordset method in VBA:
http://www.oraxcel.com/projects/sqlxl/help/vba/SQLXL/index.html
Back to top
 
« Last Edit: 24.01.07 at 12:53:32 by Gerrit-Jan Linker »  

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