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
Use excel file to insert in to a table in Oracle (Read 4464 times)
Gerrit-Jan Linker
YaBB Administrator
*****




Posts: 75
Use excel file to insert in to a table in Oracle
03.03.10 at 10:43:33
 
Use excel file to insert in to a table in Oracle
 
Quote:
Use excel file to insert in to a table in Oracle.

This table already is populated with data so I just want to append new information to it from a excel file. The excel file did NOT come from a database extract.

This would consist of 100s of rows of data. I did not see anything in Tutorial on this nor did I see where I could review to see if application will accommodate that.

Can you advise if application has this capability?

 
This is very well possible. The easiest to go about is to ensure your spreadsheet has no blank rows or columns in the area where your data resides.
Then ensure that the column headers in the spreadsheet match the column headings in the table.
After you did that, just load the multiple rows insert form. You can do that from the menu, toolbar (or ribbon in XL 2007).
You simply enter the table name, point to the column names and the data range. SQL*XL will do the rest!
 
To try this out for yourself please request an evaluation of SQL*XL Universal at:
http://www.oraxcel.com/downloads
 
More info:
*Upload Excel spreadsheet data into Oracle  
http://www.oraxcel.com/cgi-bin/yabb2/YaBB.pl?num=1167806167
*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
Back to top
 
« Last Edit: 03.03.10 at 10:48:13 by Gerrit-Jan Linker »  

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