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