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
Create Insert statements in Excel (Read 2657 times)
Gerrit-Jan Linker
YaBB Administrator
*****




Posts: 75
Create Insert statements in Excel
04.12.09 at 13:54:37
 
Create Insert statements in Excel
 
Quote:
A developer asked me for help with creating insert statments of data in an excel worksheet.
This to be inserted into a Oracle database. It takes some time to fix this, but it's possible.

Maby it should be in an nuther application like SQL*XL
The best should be to mark a range and push a button called 'Save Insert statment'

 
You can already do this in SQL*XL. From the insert functions menu you can insert the function SQLCreateInsertStatement. It generates (database specific) insert SQL. The easiest is to just logon to your database and then use the function. The function will recognise you are working with Oracle (which is the default as well I recall).
 
See also:
SQLCreateInsertStatement
http://www.oraxcel.com/projects/sqlxl/help/functions/sqlcreateinsertstatement.ht ml
Back to top
 
« Last Edit: 04.12.09 at 13:55:14 by Gerrit-Jan Linker »  

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